Select Row_number() over(Partition By t.finhospid Order By t.finhospid),t.* From tchospcomdetailh t Where t.finhospid=529226;