On Thu, 13 Sep 2001, 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;
You could use
select * from tablename limit 20
If you need to sort in some way you could use something like
select col1, col2, ... coln from tablename order by col1 limit 20
Regards,
Patrik Kudo
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
