Re: [SQL] Serial number of a record

2007-05-15 Thread Andrew Sullivan
On Tue, May 15, 2007 at 07:40:25AM -0400, [EMAIL PROTECTED] wrote: > 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. Th

[SQL] Serial number of a record

2007-05-15 Thread [EMAIL PROTECTED]
Hi List, I have one table something like this Name Age = tom 20 ram 25 shyam 30 balram15 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 outp