Postgres Pro
Downloads
Home   >   mailing lists

Restricting number of entries returned - Mailing list pgsql-sql

From Neil Burrows
Subject Restricting number of entries returned
Date
Msg-id 000101bdb028$9917b4d0$0201a8c0@taz.lenzie.net
Whole thread Raw
Responses Re: [SQL] Restricting number of entries returned  (Zsolt Varga <redax@agria.hu>)
List pgsql-sql
Tree view 
Hi,

Is there any way of restricting the number or entries returned in an SQL
query?

For example, if you wanted to do a select that ordered the results by a
certain field, and only wanted the "Top 10" entries, is there any way to
specify that you just want the 1st 10 records?

Thanks in advance,

See ya,

Neil Burrows
  /~\  /~\ /~~~~\   E-Mail   - neil@remo.demon.co.uk
  |   \| | | () /            - nburrows@cs.strath.ac.uk
  | |\   | | () \   PGP Key  - http://www.remo.demon.co.uk/pgp/
  \_/  \_/ \____/   Internet - http://www.remo.demon.co.uk/

pgsql-sql by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Typecasting in SQL functions
Next
From: Zsolt Varga
Date:
Subject: Re: [SQL] Restricting number of entries returned