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(at)sympatico(dot)ca, mikenowo(at)yahoo(dot)ca
Home Page: http://www3.sympatico.ca/mikenowo/
Lachine (Montreal), Quebec, Canada