Can EXCEPT Be Used for To Solve This Problem?
От | Lane Van Ingen |
---|---|
Тема | Can EXCEPT Be Used for To Solve This Problem? |
Дата | |
Msg-id | EKEMKEFLOMKDDLIALABIMEMGCBAA.lvaningen@esncc.com обсуждение исходный текст |
Ответы |
Re: Can EXCEPT Be Used for To Solve This Problem?
Re: Can EXCEPT Be Used for To Solve This Problem? Re: Can EXCEPT Be Used for To Solve This Problem? |
Список | pgsql-sql |
Given the following data in a table named 'foo' : id update_time description 2 2005-08-24 00:10:00 transaction1 2 2005-08-24 00:22:00 transaction2 2 2005-08-24 00:34:00 transaction3 2 2005-08-24 00:58:00 transaction4 I want to select 2nd oldest transaction from foo (transaction 3). The solution below works, but I think there may be a better way. Does anyone else have a better idea? select * from foo f1 join (select id, update_time from foo except select id, max(update_time) as update_time fromfoo group by id) f2 using (id, update_time) order by 1, 2 desc limit 1;
В списке pgsql-sql по дате отправления: