Thanks for the replies. I am looking for a simple serial no. count starting with 1,2,3......

I just have to display the customerid and customername along with a serial no. starting from 1 , so I was looking to generate this serial no. in the sql query only.

sample output if the query returned 10 records

SR No. CustomerId Customername

1 4444444 ABC

2 3332323 XYX

3 3232323 YTR

'

'

'

10 4343434 YTTT