rownumber() function is used to return the rownumber with select query
The Follwoing query will return the result set row number
תחביר
ROW_NUMBER ( ) OVER ( [
לדוגמה
Select row_number() over(order by productid) as SlNo,productname,unitprice from products
השאירו תגובה