Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] LIMIT - Mailing list pgsql-sql

From Mark Jewiss
Subject Re: [SQL] LIMIT
Date
Msg-id Pine.BSF.4.05.9904291023430.4008-100000@office.knowledge.com
Whole thread Raw
In response to Re: [SQL] LIMIT  (Chris Bitmead <chris.bitmead@bigfoot.com>)
List pgsql-sql
Tree view 
> > Could someone give me an example of a select * with LIMIT 
> > used by 6.5?
> 
> SELECT * FROM foobar LIMIT 100

Or you could use ROWCOUNT...

set rowcount = 10
select * from table

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited

pgsql-sql by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Re: [SQL] LIMIT
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] Finding the "most recent" rows