Select max value of each group

by 
select name, max(value)
from out_pumptable
group by name

More Related Contents:

  1. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  2. Select first row in each GROUP BY group?
  3. What is an index in SQL?
  4. How to split a single column values to multiple column values?
  5. What’s the difference between NOT EXISTS vs. NOT IN vs. LEFT JOIN WHERE IS NULL?
  6. T-SQL: Round to nearest 15 minute interval
  7. Designing an EAV database correctly for historical data
  8. Recursive query in SQL Server
  9. MySQL syntax for Join Update
  10. Select random row(s) in SQLite
  11. How do I remove redundant namespace in nested query when using FOR XML PATH
  12. Casting NULL type when updating multiple rows
  13. Alternatives to LIMIT and OFFSET for paging in Oracle [duplicate]
  14. How can I do a BEFORE UPDATED trigger with sql server?
  15. How do I pass a list as a parameter in a stored procedure?
  16. How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
  17. Sorting string column containing numbers in SQL?
  18. Store multiple bit values in a single table column
  19. How do I loop through a set of records in SQL Server?
  20. Grant SELECT permission on a view, but not on underlying objects
  21. Group All Related Records in Many to Many Relationship, SQL graph connected components
  22. How can I make an average of dates in MySQL?
  23. How do I call an Oracle stored procedure from an Excel VBA script?
  24. What is the best way to generate ranks in MYSQL?
  25. What does collation mean?
  26. How can I solve ORA-00911: invalid character error?
  27. Try_Convert for SQL Server 2008 R2
  28. SQL Server variable scope in a stored procedure
  29. converting int to real in sqlite
  30. What is difference between foreign key and reference key?

Leave a Comment