Re: top predicate

Have you tried using the LIMIT clause?

select porducts from sales limit 10;

http://www.postgresql.org/docs/8.1/interactive/queries-limit.html

On Thu, 11 May 2006, Karen Hill wrote:

> It seems PostgreSQL doesn't have a TOP Predicate.  Why is that?  Here
> is an example:
>
> SELECT TOP 10 products from sales;
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>