This query will add Serial or Row Numbers 1,2,3...(ascending order) in the result set of any databaseThis will add numbers ....3,2,1 (decending order)Code:SELECT CustCode, CustName, (SELECT COUNT(*) FROM Customers C2 WHERE C2.CustCode <= C.CustCode) AS SrNo FROM Customers C ORDER BY CustCodeCode:[SELECT CustCode, CustName, (SELECT COUNT(*) FROM Customers C2 WHERE C2.CustCode >= C.CustCode) AS SrNo FROM Customers C ORDER BY CustCode