Number the lines

From: yaubi(at)yaubi(dot)com (Yoann)
To: pgsql-sql(at)postgresql(dot)org
Subject: Number the lines
Date: 2001-09-14 12:05:49
Message-ID: 70c8063b.0109140405.1895bf0d@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

how can I number the result's lines of a sql query ?

explaination : I have a query which return me a list of values. I need
to order them (it's ok, easy ;) and then number the lines. The goal is
then to extract, for example, "the third maximum value".

Tx in advance !
Yoann

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bhuvan A 2001-09-14 13:25:37 How to Get Timestamp From SECONDS?
Previous Message Bhuvan A 2001-09-14 11:53:01