Horton

Re: [SQL] LIMIT

Mark Jewiss <mark@office.knowledge.com>

View thread
From: Mark Jewiss <mark@office.knowledge.com>
To: Chris Bitmead <chris.bitmead@bigfoot.com>
Cc: pgsql-sql@postgresql.org
Date: 1999-04-29T09:24:46Z
Lists: pgsql-hackers 
> > 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