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 по дате отправления
От: Kaj-Michael Lang
Дата:
От: pkeck@coe.uga.edu (Paul Keck)
Дата:
Сообщение: Soundex in Postgres?
FAQ