Re: Query

From: "Joe Conway" <joseph(dot)conway(at)home(dot)com>
To: "Tamara D(dot) Blum" <tblum(at)jus(dot)gov(dot)ar>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query
Date: 2001-09-13 22:49:39
Message-ID: 00aa01c13ca6$6133d8b0$6cdc10ac@jecw2k1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Hi !
>
> I'm trying to execute the following query:
> "SELECT TOP 10 * FROM table1"
>
> It gives me the error message
> parser: parse error at or near "2"
>
> Can i use SELECT TOP ?
> Is there any other way to execute the same query not using SELECT TOP
?
>

See the LIMIT clause:
http://www.postgresql.org/idocs/index.php?sql-select.html

Hope this helps,

-- Joe

In response to

  • Query at 2001-09-13 22:19:23 from Tamara D. Blum

Responses

  • Re: Query at 2001-09-14 09:34:36 from Thurstan R. McDougle

Browse pgsql-general by date

  From Date Subject
Next Message Gunnar Rønning 2001-09-14 00:41:02 Re: business perspective
Previous Message Mitch Vincent 2001-09-13 22:37:39 Re: Query