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.