Skip site navigation (1) Skip section navigation (2)

Re: [SQL] SELECT TOP _x_ ??

From: Chairudin Sentosa <chairudin(at)prima(dot)net(dot)id>
To: Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com>
Cc: pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] SELECT TOP _x_ ??
Date: 1999-04-23 08:36:15
Message-ID: 372030FF.FCB6D1D4@prima.net.id (view raw or flat)
Thread:
Lists: pgsql-sql
I tried this, did not work.

ibs=> select * from ibs_subscriber limit 5;
ERROR:  parser: syntax error at or near "5"

Regards,
Chai

PS: PostgreSQL 6.5 snapshot.

Chris Bitmead wrote:

> Justin Long wrote:
> >
> > In Microsoft SQL Server you could issue a command
> >
> >         SELECT TOP 5 * FROM database...
>
> SELECT * FROM TABLE LIMIT 5;
>
> You may have to be running 6.5, not sure.
>
> --
> Chris Bitmead
> http://www.bigfoot.com/~chris.bitmead
> mailto:chris(dot)bitmead(at)bigfoot(dot)com


In response to

Responses

pgsql-sql by date

Next:From: Chairudin SentosaDate: 1999-04-23 09:13:12
Subject: Re: [INTERFACES] where did that date and time come from??
Previous:From: Chairudin SentosaDate: 1999-04-23 08:34:42
Subject: Re: [SQL] Finding the "most recent" rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group