How to achive Oracle Rownum with Order by clause equalent in SQL server script

• manavairajan

  Right there with Babe

  Points: 781

  More actions

  April 10, 2019 at 7:42 am

  #3084868

  Hi Everyone,

  I hope, you are doing good!

  I have a requirment to migrage all oracle open query into Microsoft SQL Query. There am facing issue as: There were used ROWNUM with Order by clause and which is returning a result. But similar iam trying to get in SQL using order by with Top number rows. But, given resulst entirly wrong.

  So, can you please guide me how to achive this? Also, Please explain about Oracle how it performing(what algoritham) Rownum with order by clause.

  Thanks in advance for your helping.

• saravanatn

  SSCarpal Tunnel

  Points: 4533

  More actions

  April 10, 2019 at 9:22 am

  #3086517

  rownum equivalent in sql server is ROW_NUMBER. Kindly refer below link to know more.

   

  https://docs.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-2017

  https://www.c-sharpcorner.com/blogs/rownumber-function-with-partition-by-clause-in-sql-server1

  • This reply was modified 5 years, 8 months ago by  saravanatn.

  Saravanan