Something like this

SELECTH.CtryId, H.WrkflwId, H.Dt

FROMstepHistory H

INNER JOIN(

SELECTWrkflwId, ctryId, MAX( DtTm ) AS DtTm

FROMstepHistory

GROUP BY WrkflwId, ctryId

) AS SH ON H.WrkflwId = SH.WrkflwId AND H.CtryId = SH.CtryId AND H.DtTm = SH.DtTm

WHEREH.SteTyId = 2