Re: top?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Richard Rowell <rwrowell(at)bellsouth(dot)net>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: top?
Date: 2002-01-03 23:48:06
Message-ID: 20020103154644.J15005-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

In response to

  • top? at 2002-01-03 23:27:59 from Richard Rowell

Responses

  • Re: top? at 2002-01-04 01:59:47 from Christopher Kings-Lynne

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-01-04 01:59:47 Re: top?
Previous Message Richard Rowell 2002-01-03 23:27:59 top?