picking max from list
| От | Jodi Kanter |
|---|---|
| Тема | picking max from list |
| Дата | |
| Msg-id | 3FD783F6.6030801@virginia.edu обсуждение исходный текст |
| Ответы |
Re: picking max from list
Re: picking max from list |
| Список | pgsql-sql |
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 по дате отправления: