SQL

How to get Row Number with the result of SQL select query?

5
(2)

Try the following code to get Row Number…

SELECT ROW_NUMBER() OVER (ORDER BY PRODUCTID ASC) AS ROWNO, * FROM PRODUCT_MASTER

Thank You

How useful was this post?

Click on a star to rate it!

Leave a Reply

Your email address will not be published. Required fields are marked *