Can you get a whole row with a max on one column
От
Scott V. McGuire
Тема
Can you get a whole row with a max on one column
Дата
Msg-id
20000127142610.A2849@syr.edu
Список
Дерево обсуждения
Can you get a whole row with a max on one column "Scott V. McGuire" <svmcguir@syr.edu>
Re: [GENERAL] Can you get a whole row with a max on one column Yury Don <yura@vpcit.ru>
I have a table with these columns (and more but irrelevant ones) | magnetic_susceptibility | float8 | spin_coupling | float8 | boundary_coupling | float8 I want a query to give (spin_coupling, boundary_coupling) where for each boundary_coupling it gives the spin_coupling for which magnetic_susceptibility is maximum. Kinda like: select boundary_coupling, max(magnetic_susceptibility) from run_averages group by boundary_coupling; except I don't want to see max(magnetic_susceptibility) but the spin_coupling which corresponds to max(magnetic_susceptibility). I know I can do this with a small program, but I would like to have a single query so that I can use psql -c "query" in a script and pipe the results to a file. Thanks, -- Scott V. McGuire GnuPG key available at http://physics.syr.edu/~svmcguir GnuPG key fingerprint: 21EA 4999 3620 3E1D 71EC 98A9 5B9B EF52 1258 6D53 GnuPG is at http://www.gnupg.org/
В списке pgsql-general по дате отправления