get certain # of recs

Поиск
Список
Период
Сортировка
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?

Thx,
--
=============================================
 Mike S. Nowostawsky:
 Email: mikenowo@sympatico.ca, mikenowo@yahoo.ca
 Home Page: http://www3.sympatico.ca/mikenowo/
 Lachine (Montreal), Quebec, Canada



В списке pgsql-general по дате отправления: