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@ritterdosreis.br
> Cel.: (51)91287530
> Linux Counter #281893
>
> Faculdade Ritter dos Reis
> www.ritterdosreis.br
> felipes@ritterdosreis.br
> Fone/Fax.: (51)32303328
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

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