limiting the rows selected in postgresql

Поиск
Список
Период
Сортировка
Искать
От
RADHAKRISHNAN C V
Тема
limiting the rows selected in postgresql
Дата
Msg-id
Pine.OSF.3.95.981109182032.10351B-100000@md2.vsnl.net.in
Ответ на
Re: [INTERFACES] crypt not included when compiling libpgtcl !!!!!!! (Constantin Teodorescu)
Список
Дерево обсуждения
Re: [INTERFACES] limiting the rows selected in postgresql Sferacarta Software <sferac@bo.nettuno.it>
Re: [INTERFACES] limiting the rows selected in postgresql Sergio <ser@perio.unlp.edu.ar>
Re: [INTERFACES] limiting the rows selected in postgresql Oleg Bartunov <oleg@sai.msu.su>
Re: [INTERFACES] limiting the rows selected in postgresql A James Lewis <james@vrtx.net> 

how can i limit the number of rows obtained from a select statement
in postgreSQL to say, 10 rows while the select condition  actually
matches more than that. in oracle we can use the ROW_NUM variable
for this purpose but now i met such an issue with postgreSQL

thanks in advance

CV Radhakrishnan

http://www.river-valley.com
В списке pgsql-interfaces по дате отправления
Предыдущее
От: Jim Bowlin
Дата:
Следующее
От: Sferacarta Software
Дата:
FAQ