Postgres Pro
Downloads
Home   >   mailing lists

How to select and result row number?? - Mailing list pgsql-sql

From Yudie
Subject How to select and result row number??
Date
Msg-id 001301c25b5a$2ef0ea40$8a01a8c0@yudie
Whole thread Raw
Responses Re: How to select and result row number??  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: How to select and result row number??  (Roland Roberts <roland@astrofoto.org>)
List pgsql-sql
Tree view
Hi,
 
I would like to select and also give numbering in each record.
Let say I have table 'City' with a 'cityname' column
 
what is the select statement so I can get result records like this
 
no   cityname
----  --------------
1     NEW YORK
2     LOS ANGELES
3     HOUSTON
4     ....
5     ...
 
Thank you.
 
Yudie
 

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Want to test beta, but ...
Next
From: Tom Lane
Date:
Subject: Re: Timestamp Fractions Problem