| From: | Mintoo Lall <tlqmail(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Generating serial number column |
| Date: | 2003-02-13 16:21:56 |
| Message-ID: | 20030213162156.26511.qmail@web14805.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi Everybody ,
Is there a way in postgresql by which I can generate serial number column for the
resultset. I wanted the resulset to look like below
sno Name
-------------------
1 JOE
2 JOHN
3 MARY
4 LISA
5 ANN
6 BILL
7 JACK
8 WILL
9 GEORGE
10 NANCY
11 JANE
. .
. .
. .
My query is basically select * name from tblcontact. I wanted to generate
the column "sno" which basically numbers each row returned. Any help is
appreciated.
Regards,
Tarun
---------------------------------
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
| From | Date | Subject | |
|---|---|---|---|
| Next Message | piuschan | 2003-02-13 16:35:14 | pg_restore fails when restoring a database view |
| Previous Message | Tom Lane | 2003-02-13 15:17:57 | Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select |