Re: [SQL] SELECT TOP _x_ ??

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