Re: limiting rows in an query

From: Michael Paesold <mpaesold(at)gmx(dot)at>
To: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: limiting rows in an query
Date: 2002-09-30 13:27:15
Message-ID: 20219.1033392435@www54.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

SELECT * FROM "inscricoes" LIMIT 30 OFFSET 0;

Best regards, Michael Paesold

--
Werden Sie mit uns zum "OnlineStar 2002"! Jetzt GMX wählen -
und tolle Preise absahnen! http://www.onlinestar.de

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andrew Sullivan 2002-09-30 14:51:02 Re: PostgreSQL JDBC - Number of connections
Previous Message Varun Kacholia 2002-09-30 13:17:26 Re: limiting rows in an query