Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] SELECT TOP _x_ ?? - Mailing list pgsql-sql

From Chris Bitmead
Subject Re: [SQL] SELECT TOP _x_ ??
Date
Msg-id 371F355F.7551BAAB@bigfoot.com
Whole thread Raw
In response to SELECT TOP _x_ ??  ("Justin Long" <justinlong@strategicnetwork.org>)
List pgsql-sql
Tree view 
Justin Long wrote:
> 
> In Microsoft SQL Server you could issue a command
> 
>         SELECT TOP 5 * FROM database...

SELECT * FROM TABLE LIMIT 5;

You may have to be running 6.5, not sure.

-- 
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com

pgsql-sql by date:

Previous
From: "Justin Long"
Date:
Subject: SELECT TOP _x_ ??
Next
From: Chris Bitmead
Date:
Subject: Re: [SQL] Finding the "most recent" rows