Re: get certain # of recs - Mailing list pgsql-general

From Philip Hallstrom
Subject Re: get certain # of recs
Date
Msg-id 20010914143455.L93708-100000@teak.adhesivemedia.com
Whole thread Raw
In response to get certain # of recs  ("Mike S. Nowostawsky" <mikenowo@sympatico.ca>)
List pgsql-general
Take a look at the LIMIT part of the SELECT statement.  in your case you'd
do:

select  * from tablename limit 21;

ALthough you'll want to use an ORDER BY otherwise you could get different
results each time..

-philip

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;
>
> WHAT should 'rownum' be to make this select work... OR is there a diff
> syntax?
>
> Thx,
> --
> =============================================
>  Mike S. Nowostawsky:
>  Email: mikenowo@sympatico.ca, mikenowo@yahoo.ca
>  Home Page: http://www3.sympatico.ca/mikenowo/
>  Lachine (Montreal), Quebec, Canada
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


pgsql-general by date:

Previous
From: "Jeff Eckermann"
Date:
Subject: Re: error while generating and EXECUTEing a query dynamically
Next
From: "Eric Ridge"
Date:
Subject: Re: count of occurences