Skip site navigation (1) Skip section navigation (2)

Support for SQL TOP clause?

From: "Chinyi Woo" <chinyi(dot)woo(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Support for SQL TOP clause?
Date: 2008-01-10 03:13:56
Message-ID: f5ba57b40801091913y53833e1dh78592e5bc4a24d57@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
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

Responses

pgsql-sql by date

Next:From: Phillip SmithDate: 2008-01-10 03:19:43
Subject: Re: Support for SQL TOP clause?
Previous:From: Jamie TufnellDate: 2008-01-09 23:30:42
Subject: Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group