query: select top newest records of different distinct column
positive_passages.docid: 16341
positive_passages.text: mySQL Returning the top 5 of each category
negative_passages.docid: 15594
negative_passages.text: Select the row with the maximum value in each group
negative_passages.docid: 17434
negative_passages.text: Get rows with most recent date for each different item
negative_passages.docid: 88745
negative_passages.text: How do I delete records in MySQL and keep the lastest date
negative_passages.docid: 66879
negative_passages.text: How to get next/previous record in MySQL?
negative_passages.docid: 93927
negative_passages.text: Display Top X results for each unique value
negative_passages.docid: 91217
negative_passages.text: Arbitrarily ordering records in a table
negative_passages.docid: 21641
negative_passages.text: Remove duplicate entries, keeping latest only
negative_passages.docid: 71713
negative_passages.text: PostgreSQL - "DISTINCT ON" and "GROUP BY" syntax
negative_passages.docid: 155343
negative_passages.text: Select multiple (non-aggregate function) columns with GROUP BY
negative_passages.docid: 39628
negative_passages.text: SQL select only rows with max value on a column
negative_passages.docid: 32521
negative_passages.text: MySQL COUNT DISTINCT
negative_passages.docid: 16123
negative_passages.text: How to find rows that have maximum value?
negative_passages.docid: 145393
negative_passages.text: Filter query result by most recent date
negative_passages.docid: 96534
negative_passages.text: Efficiently select beginning and end of multiple contiguous ranges in Postgresql query
negative_passages.docid: 90459
negative_passages.text: Select top 10 records for each category
negative_passages.docid: 144830
negative_passages.text: How to select the most recent set of dated records from a mysql table