Обсуждение: Function TOP

Is there in Postgres such a function like TOP in MSSQL?

If the data is sorted, you can add "... LIMIT <number of records you want,
i.e. 10> ;" at the end of the query.  If you want a percentage (like TOP
10%) you will have to first find out (maybe with COUNT()) how many records
apply and then do a little math to find out what the number of your LIMIT
clause should be.

Len Morgan

-----Original Message-----
From: Tomasz Janyska <tjanyska@laser.pl>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Tuesday, January 02, 2001 1:25 PM
Subject: [GENERAL] Function TOP


>Is there in Postgres such a function like TOP in MSSQL?
>
>
>

Tomasz Janyska wrote:

> Is there in Postgres such a function like TOP in MSSQL?

LIMIT.  You need an order by clause for the results to be meaningful.