limiting rows in an query

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: limiting rows in an query
Date: 2002-09-30 13:09:15
Message-ID: 1033391355.1257.6.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Varun Kacholia 2002-09-30 13:17:26 Re: limiting rows in an query
Previous Message Jochem van Dieten 2002-09-30 10:19:41 Re: [JDBC] Prepared statement performance...