SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY GroupID ORDER BY GroupID) ID,* FROM tab_Users) NEWTABLE WHERE ID = 1