Restricting number of entries returned

From: "Neil Burrows" <neil(at)remo(dot)demon(dot)co(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Restricting number of entries returned
Date: 1998-07-15 19:41:44
Message-ID: 000101bdb028$9917b4d0$0201a8c0@taz.lenzie.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)remo(dot)demon(dot)co(dot)uk
| \| | | () / - nburrows(at)cs(dot)strath(dot)ac(dot)uk
| |\ | | () \ PGP Key - http://www.remo.demon.co.uk/pgp/
\_/ \_/ \____/ Internet - http://www.remo.demon.co.uk/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Zsolt Varga 1998-07-15 22:06:38 Re: [SQL] Restricting number of entries returned
Previous Message Jackson, DeJuan 1998-07-15 17:43:46 RE: [SQL] Typecasting in SQL functions