;with tblA (num) As ( Select 1 Union All Select 1 Union All Select 2 Union All Select 2 Union All Select 3 Union All Select 4 Union All Select 5 Union All Select 5 Union All Select 5 ) Select a.num ,a.seq From ( Select a.num ,Row_number() Over(Partition By a.num Order by a.num) As seq From tblA a ) a Order By a.num ,a.seq
(
Select 1 Union All
Select 1 Union All
Select 2 Union All
Select 2 Union All
Select 3 Union All
Select 4 Union All
Select 5 Union All
Select 5 Union All
Select 5
)
Select a.num
,a.seq
From (
Select a.num
,Row_number() Over(Partition By a.num Order by a.num) As seq
From tblA a
) a
Order By a.num
,a.seq