get certain # of recs
От | Mike S. Nowostawsky |
---|---|
Тема | get certain # of recs |
Дата | |
Msg-id | C_eo7.29408$2r.2992264@news20.bellglobal.com обсуждение исходный текст |
Ответы |
Re: get certain # of recs
Re: get certain # of recs Re: get certain # of recs Re: get certain # of recs |
Список | pgsql-general |
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 по дате отправления: