How do i find the largest value in a column in postgres sql?

sql postgresql max
diesel picture diesel · Feb 6, 2011 · Viewed 66.4k times · Source

For example:

name | weight
jon    100    
jane   120    
joe    130

How do I only return the name of the person with the largest weight?

Answer

raveren picture raveren · Dec 5, 2012 
SELECT name FROM tbl ORDER BY weight DESC LIMIT 1

Much more performant than the other answer and results in one row only.

Related questions

PostgreSQL MAX and GROUP BY

I have a table with id, year and count. I want to get the MAX(count) for each id and keep the year when it happens, so I make this query: SELECT id, year, MAX(count) FROM table GROUP BY …

Read More
Postgresql turn null into zero

Possible Duplicate: SELECT max(x) is returning null; how can I make it return 0? When I execute select max(column) from mytable; and my table has no rows, it returns null. How can I amend this select statement so it …

Read More
Performance of max() vs ORDER BY DESC + LIMIT 1

I was troubleshooting a few slow SQL queries today and don't quite understand the performance difference below: When trying to extract the max(timestamp) from a data table based on some condition, using MAX() is slower than ORDER BY timestamp …

Read More