Re: select only the first record
От | Jan Wieck |
---|---|
Тема | Re: select only the first record |
Дата | |
Msg-id | 200107101331.f6ADVk914719@jupiter.us.greatbridge.com обсуждение исходный текст |
Ответ на | select only the first record (juerg.rietmann@pup.ch) |
Список | pgsql-sql |
juerg.rietmann@pup.ch wrote: > Hello there > > Is it possible to do a query and selecting only the first record in ad > table ? > > e.g. select FIRST * from cars You can either use a CURSOR and FETCH only the first row, or use LIMIT (non-standard). And you might want to explicitly ORDER the result set, otherwise exchange "FIRST" with "ONE-RANDOM" in your question. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
В списке pgsql-sql по дате отправления: