Select info from table where row has max date

by 
SELECT group,MAX(date) as max_date
FROM table
WHERE checks>0
GROUP BY group

That works to get the max date..join it back to your data to get the other columns:

Select group,max_date,checks
from table t
inner join 
(SELECT group,MAX(date) as max_date
FROM table
WHERE checks>0
GROUP BY group)a
on a.group = t.group and a.max_date = date

Inner join functions as the filter to get the max record only.

FYI, your column names are horrid, don’t use reserved words for columns (group, date, table).

More Related Contents:

  1. Get top 1 row of each group
  2. Select top 10 records for each category
  3. SQL server select distinct rows using most recent value only
  4. Select first row in each GROUP BY group?
  5. Insert results of a stored procedure into a temporary table
  6. GROUP BY with MAX(DATE) [duplicate]
  7. How to SELECT the newest four items per category?
  8. How important is the order of columns in indexes?
  9. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  10. sql query to return differences between two tables
  11. Difference between a User and a Login in SQL Server
  12. Convert Xml to Table SQL Server
  13. Fastest way to update 120 Million records
  14. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  15. How to find current transaction level?
  16. How do I group on continuous ranges
  17. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  18. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  19. Extracting hours from a DateTime (SQL Server 2005)
  20. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  21. How to escape square brackets inside square brackets for field name
  22. How do you copy a record in a SQL table but swap out the unique id of the new row?
  23. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  24. How do I find the data directory for a SQL Server instance?
  25. Add a row number to result set of a SQL query
  26. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?
  27. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  28. Backup SQL Schema Only?
  29. Get most common value for each value of another column in SQL
  30. PostgreSQL: top n entries per item in same table

Leave a Comment