Re: [GENERAL] max() question
От | Michael Simms |
---|---|
Тема | Re: [GENERAL] max() question |
Дата | |
Msg-id | 199909141843.TAA10165@argh.demon.co.uk обсуждение исходный текст |
Ответ на | Re: [GENERAL] max() question ("Aaron J. Seigo" <aaron@gtv.ca>) |
Список | pgsql-general |
> > On Tue, 14 Sep 1999, you wrote: > > I have a table with and email address and a datetime timestamp. What > > would be the easiest way to select the 3 earliest timestamps (earliest > > being furthest in the past from the current date) > > lots of ways =) though the first that comes to mind is the use of cursors. > order by DATEFIELD asc and just grab the first three.. or if that don't work for > ya (for whatever reason)... you could select the min(DATEFIELD), then select the > min(DATEFIELD) where DATEFIELD > (that last select's return), then again for > the third... this is convoluted, but if you are doing this over a network, a > cursor may not be the easiest thing to implement, depending on what you are > using. as for performance of this? i dunno. cursor would be best. Hows about: select * from table order by timestamp limit 3 That should do it ~Michael
В списке pgsql-general по дате отправления: