| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres SQL List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | picking max from list |
| Date: | 2003-12-10 20:37:10 |
| Message-ID: | 3FD783F6.6030801@virginia.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
--
/_______________________________
//Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>/
/ /
/ /
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-12-10 20:53:40 | Re: picking max from list |
| Previous Message | Tom Lane | 2003-12-10 16:12:16 | Re: How to completely move a table to another schema? |