Use something like TOP with GROUP BY...

Get MAX row for GROUP in MySQL...

Optimizing SQL Query for max value with various conditions from a single MySQL table...

Oracle SQL query: Retrieve latest values per group based on time...

Per each record, select also the data with the highest value for the record...

Using order_by and group_by in CodeIgniter not working as expected...

How to query datetime column - MS SQL 2008...

PostgreSQL: Customers preferred product and second most preferred product...

How to retrieve top 3 results for each column in postgresql?...

How to show only first result from select?...

Find next consecutive row by order_num field...

Oracle: max value of each observation, and all rows associated with max value...

Query to get identifier and aggregate function value of a row...

MySQL: how to get x number of results per grouping...

SQL:Last date of Join table...

Retrieve the highest value in a one-to-many-relationship...

PostgreSQL: top n entries per item in same table...

POSTGRESQL : How to select the first row of each group?...

SQL Server Greatest n per Group Query: Customer Information with Latest Date...

SQL Group sort by date...

How to select the maximum value in each group where group having a condition...

how to get the latest price in sql query...

SQL: Filter on one column, then select max timestamp for results...

Result that returns multiple groups based on id and date...

SQL Query taking forever is my query properly formatted?...

Select top N rows out of M groups...

SQL: Identifying latest max sequence per row...

Oracle SQL - Efficient Join N Rows Per Match...

In R, looking for better way to get the max value out of subgroups (groups within groups)...

Oracle SQL Return Most Recent and Next Most Recent Price and Date...