hi, there are some record stored in a table and i want to retrieve some record , can i add serials numbers in front of every record?
i.e there is a table
index name designation
1 tom clerk
.
.
22 jeck clerk
.
.
100 Harry clerk
.
.
1001 Rohit clerk
a table like this…
i want out put like this
- tom clerk
- jeck clerk
- harry clerk
- rohit clerk
means i want a serial no. with every record from database…
as 1,2,3,4 are the serial no. for every record , as its not stored in database… but i want to add it in out put…
and iwant to use this serial no further in my programe…