Simulating ORACLE ROWNUM in SQL Server:
Here is the approach you can use to generate a pseudo row number in SQL Server.The table format and data:select * from Ac1 c2-----101 0102 0103 0(3 row(s) affected)Approach 1:select rank=count(*),a.c1,a.c2 from A a ,A bwhere a.c1+a.c2 > = b.c1+b.c2group by a.c1,a.c2rank c1 c2-----------1 101 02 102 03 103 0(3 row(s) affected)Approach 2 :select rank() OVER (ORDER BY a.c1,a.c2) as rank,a.c1,a.c2from A aorder by rankrank c1 c2--------------------1 101 02 102 03 103 0(3 row(s) affected)Finally very very simple...
