Top "Greatest-n-per-group" questions

I have the following data in my database: |NO | model | date | +---+-------+----------+ |1 | bee |2011-12-01| |2 | bee |2011-12-05| |3 | …

For an example, I would like to select id with max date group by category, the result is: 7, 2, 6 id category …

I am trying to select of the duplicate rows in mysql table it's working fine for me but the problem …

I have the following mySQL query that works perfectly fine. Except that I need to add a "FORCE INDEX" and …

Let's say I have a table called messages with the columns: id | from_id | to_id | subject | message | timestamp I …

I am storing the response to various rpc calls in a mysql table with the following fields: Table: rpc_responses …

I'm hoping there's a simple way to do this without using a sub-query: Scenario: You have "TableA" with columns "Key", "…

How would I be able to get N results for several groups in an oracle query. For example, given the …

Possible Duplicate: Retrieving the last record in each group I have one table, which has three fields and data. Name , …

I am trying to select the max value from one column, while grouping by another non-unique id column which has …