Postgres Pro
Downloads
Home   >   mailing lists

Support for SQL TOP clause? - Mailing list pgsql-sql

From Chinyi Woo
Subject Support for SQL TOP clause?
Date
Msg-id f5ba57b40801091913y53833e1dh78592e5bc4a24d57@mail.gmail.com
Whole thread Raw
Responses Re: Support for SQL TOP clause?  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
Re: Support for SQL TOP clause?  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-sql
Tree view
Hello, everyone
Does Postgresql support query like SELECT TOP 3 * FROM Individual  ? If I use ORDER BY, I have to write non-sql code to get the first row in the result set, which I try to avoid.
 
Thanks
Chinyi

pgsql-sql by date:

Previous
From: "Jamie Tufnell"
Date:
Subject: Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..?
Next
From: "Phillip Smith"
Date:
Subject: Re: Support for SQL TOP clause?