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

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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx