Re: limiting rows in an query

Hi ,

Postgresql also follows the same syntax.

SELECT select_list
FROM table_expression
[LIMIT { number | ALL }] [OFFSET number]

On Mon, Sep 30, 2002 at 10:09:15AM -0300, Felipe Schnack wrote:
> In MySQL I can get the first 30 rows in an query doing this:
> SELECT * FROM `inscricoes` LIMIT 0, 30
> How I do this in pgsql?
> --
>
> Felipe Schnack
> Analista de Sistemas
> felipes(at)ritterdosreis(dot)br
> Cel.: (51)91287530
> Linux Counter #281893
>
> Faculdade Ritter dos Reis
> www.ritterdosreis.br
> felipes(at)ritterdosreis(dot)br
> Fone/Fax.: (51)32303328
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Varun
------
Do not kill time ... else time will kill you