From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | Ian Barwick <SUNGLASSESbarwick(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: get certain # of recs |
Date: | 2001-09-14 14:58:25 |
Message-ID: | 20010914145825.73798.qmail@web13406.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You might also want to look at the SQL command
CLUSTER, which physically reorders the table rows
based upon an existing index.
Andrew Gould
--- Ian Barwick <SUNGLASSESbarwick(at)gmx(dot)net> wrote:
> 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 ;-)
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
From | Date | Subject | |
---|---|---|---|
Next Message | chris_five | 2001-09-14 15:01:12 | Re: Blob datatype / image storing |
Previous Message | Mariusz Jadczak | 2001-09-14 14:36:10 | commercial usage with odbc |