Re: top?

> On Thu, 3 Jan 2002, Richard Rowell wrote:
>
> > Just wondering if there was a "TOP" equivilant in Postgres?
> > IE
> > select top 1 * from froo
> > (only returns 1 row)
>
> select * from froo limit 1;
>
> Usually you'll want to order as well so that you get a meaningfully
> chosen row rather than whatever row happens to be scanned first.

Actually I think its essential that he orders it.  I think the 'top' thing
is a microsoft-ism that gets the 'top 10 items' say from a column.  I can't
remember if it's the 10 with the highest values or the ten with the most
common values...

Chris