Re: Support for SQL TOP clause?

From: Reinoud van Leeuwen <reinoud(dot)v(at)n(dot)leeuwen(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Support for SQL TOP clause?
Date: 2008-01-10 11:46:23
Message-ID: 20080110114623.GF41164@spoetnik.xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jan 10, 2008 at 02:19:43PM +1100, Phillip Smith wrote:
> SELECT *
>
> FROM Individual
>
> LIMIT 3

Note that you will have to add an 'order by' clause to guarantee
predictable results...

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen reinoud(dot)v(at)n(dot)leeuwen(dot)net
http://www.xs4all.nl/~reinoud
__________________________________________________

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2008-01-10 13:56:44 Re: Support for SQL TOP clause?
Previous Message Paul Lambert 2008-01-10 08:04:04 Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...)