Hi Everybody ,<br /><br />Is there a way in postgresql by which I can generate serial number column for the<br
/>resultset.I wanted the resulset to look like below<br /><br /><br />sno Name<br />-------------------<br
/>1 JOE<br />2 JOHN<br />3 MARY<br />4 LISA<br
/>5 ANN<br />6 BILL<br />7 JACK<br />8 &nb sp; WILL<br
/>9 GEORGE<br />10 NANCY<br />11 JANE<br /> . .<br
/> . .<br /> . .<br /><br />My query is basically select * name from tblcontact. I
wantedto generate<br />the column "sno" which basically numbers each row returned. Any help is<br />appreciated.<br
/>Regards,<br/>Tarun<br /><p><br /><hr size="1" />Do you Yahoo!?<br /><a
href="http://rd.yahoo.com/O=1/I=brandr/vday03/text/flow/*http://shopping.yahoo.com
/shop?d=browse&id=20146735">Yahoo! Shopping</a> - Send Flowers for Valentine's Day