picking max from list
От
Jodi Kanter
Тема
picking max from list
Дата
Msg-id
3FD783F6.6030801@virginia.edu
Список
Дерево обсуждения
picking max from list Jodi Kanter <jkanter@virginia.edu>
Re: picking max from list Bruno Wolff III <bruno@wolff.to>
Re: picking max from list Guy Fraser <guy@incentre.net>
I have a query that produces results similar to this:
run# rd_pk group#
0 9209 5
1 9209 8
0 9520 2
1 9520 5
0 9520 etc....
0 8652
1 8652
2 8652
0 8895
1 8894
Ultimately I want to know the group number for EACH rd_pk with the highest run number. Can this be done in one query? Or will I need to code with a loop?
Thanks
Jodi
run# rd_pk group#
0 9209 5
1 9209 8
0 9520 2
1 9520 5
0 9520 etc....
0 8652
1 8652
2 8652
0 8895
1 8894
Ultimately I want to know the group number for EACH rd_pk with the highest run number. Can this be done in one query? Or will I need to code with a loop?
Thanks
Jodi
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
В списке pgsql-sql по дате отправления
