From: | Ian Barwick <SUNGLASSESbarwick(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: get certain # of recs |
Date: | 2001-09-14 10:35:40 |
Message-ID: | 9nsmg6$1bip$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Mike S. Nowostawsky wrote:
> How can one select only a certain number of records in Postgres?
>
> In other SQL langs we can use, say, for the first 20 recs:
>
> select * from tablename where rownum < 21;
>
> WHAT should 'rownum' be to make this select work... OR is there a diff
> syntax?
use the LIMIT clause, e.g.
SELECT * FROM tablename LIMIT 20
for the first 20 rows, or
SELECT * FROM tablename LIMIT 10,20
for 10 rows beginning from the 20th row (or possibly the other way round,
the caffeine isn't working yet ;-)
When using LIMIT it is generally advisable to also use ORDER BY in order to
guarantee consistent result sets over repeated queries.
HTH
Ian Barwick
--
Ian Barwick - Developer
http://www.akademie.de
Remove SUNGLASSES to reply ;-)
From | Date | Subject | |
---|---|---|---|
Next Message | Thurstan R. McDougle | 2001-09-14 12:21:30 | Re: count of occurences PLUS optimisation |
Previous Message | Giorgio Volpe | 2001-09-14 10:13:52 | Re: where cannot use alias name of column? |