Hi List, I have one table something like this
Name Age ================= tom 20 ram 25 shyam 30 balram 15 hari 10 Now i want serial number of a record. Suppose if i will fire a query "select Name from tablename where age=30". it will give output "shyam" but i also want record no. other then oid, in this case it is 3. is it possible? if yes then how? plz. help me. Thanks Ashok -------------------------------------------------------------------- mail2web.com - Microsoft® Exchange solutions from a leading provider - http://link.mail2web.com/Business/Exchange ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend