Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 57669476165 for ; Fri, 13 Sep 2002 15:16:39 -0400 (EDT) Received: from axiontech.com (unknown [216.52.172.74]) by postgresql.org (Postfix) with SMTP id 888094760A4 for ; Fri, 13 Sep 2002 15:16:38 -0400 (EDT) Received: (qmail 12539 invoked from network); 13 Sep 2002 19:16:39 -0000 Received: from pc-00138 (HELO yudie) (192.168.1.138) by mail.axiontech.com (192.168.1.6) with SMTP; 13 Sep 2002 19:16:39 -0000 Message-ID: <001301c25b5a$2ef0ea40$8a01a8c0@yudie> From: "Yudie" To: Subject: How to select and result row number?? Date: Fri, 13 Sep 2002 14:17:13 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000E_01C25B30.41545980" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/147 X-Sequence-Number: 9424 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C25B30.41545980 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_000E_01C25B30.41545980 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I would like to select and also give numbe= ring in=20 each record.

Let say I have table 'City' with a 'cityna= me'=20 column

what is the select statement so I can get = result=20 records like this

no cityname

---- --------------

1 NEW YORK<= /DIV>

2 LOS ANGELES

3 HOUSTON

4 ....

5 ...

Thank you.

Yudie

------=_NextPart_000_000E_01C25B30.41545980--