Re: get certain # of recs
От
Stephan Szabo
Тема
Re: get certain # of recs
Дата
Msg-id
Pine.BSF.4.21.0109141525430.43854-100000@megazone23.bigpanda.com
Ответ на
get certain # of recs (Mike S. Nowostawsky)
Список
Дерево обсуждения
get certain # of recs "Mike S. Nowostawsky" <mikenowo@sympatico.ca>
Re: get certain # of recs Philip Hallstrom <philip@adhesivemedia.com>
Re: get certain # of recs Jason Earl <jdearl@yahoo.com>
Re: get certain # of recs Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: get certain # of recs Patrik Kudo <kudo@partitur.se>
On Thu, 13 Sep 2001, Mike S. Nowostawsky wrote: > How can one select only a certain number of records in Postgres? > > In other SQL langs we can use, say, for the first 20 recs: > > select * from tablename where rownum < 21; > > WHAT should 'rownum' be to make this select work... OR is there a diff > syntax? select * from tablename LIMIT 20;
В списке pgsql-general по дате отправления
