Hi all
I have a table customers with fields
custcode
custname
city


SELECT srno, custname FROM customers ORDER BY custname

In this query, srno should increament automatically.
Is it possible?

I want to fire a query which will give me following result.
1 customer1
2 customer2
etc

Thanks