Received: from akirason.se.verio.net (akirason.se.verio.net [204.27.64.122]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8EIoc756374 for ; Fri, 14 Sep 2001 14:50:38 -0400 (EDT) (envelope-from jeckermann@verio.net) Received: from beancounter (no-wkstns.gs.verio.net [204.27.67.225]) (authenticated) by akirason.se.verio.net (8.11.4/8.11.4) with ESMTP id f8EIs8I15751; Fri, 14 Sep 2001 13:54:10 -0500 (CDT) (envelope-from jeckermann@verio.net) Message-ID: <020301c13d4e$1d1d7de0$279c10ac@INTERNAL> From: "Jeff Eckermann" To: "Yoann" , References: <70c8063b.0109140405.1895bf0d@posting.google.com> Subject: Re: Number the lines Date: Fri, 14 Sep 2001 13:50:15 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200109/87 X-Sequence-Number: 4747 If you want "the third maximum value", easist to do: SELECT * FROM table ORDER BY whatever DESC OFFSET 2 LIMIT 1; ----- Original Message ----- From: "Yoann" To: Sent: Friday, September 14, 2001 7:05 AM Subject: Number the lines > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >