query: Limit SQL query to only the top two counts per group
positive_passages.docid: 9045
positive_passages.text: Get top results for each group (in Oracle)
negative_passages.docid: 122278
negative_passages.text: MySQL - How to count all rows per table in one query
negative_passages.docid: 42491
negative_passages.text: How do I efficiently get "the most recent corresponding row"?
negative_passages.docid: 16123
negative_passages.text: How to find rows that have maximum value?
negative_passages.docid: 85400
negative_passages.text: How to get the count of each distinct value in a column?
negative_passages.docid: 38452
negative_passages.text: SQL Not A Single Group Group Function
negative_passages.docid: 68780
negative_passages.text: Limit on the WHERE col IN (...) condition
negative_passages.docid: 56731
negative_passages.text: How do I count query result rows?
negative_passages.docid: 124091
negative_passages.text: Showing only the top 5 results
negative_passages.docid: 108056
negative_passages.text: Returning a result set with multiple rows based on max date
negative_passages.docid: 100646
negative_passages.text: MySQL - Using COUNT(*) in the WHERE clause
negative_passages.docid: 46339
negative_passages.text: How do I compare 2 rows from the same table (SQL Server)?
negative_passages.docid: 118546
negative_passages.text: In SQL, how can you "group by" in ranges?
negative_passages.docid: 8237
negative_passages.text: How do I limit the number of rows returned by an Oracle query after ordering?
negative_passages.docid: 89385
negative_passages.text: How do I use T-SQL Group By
negative_passages.docid: 62300
negative_passages.text: Mysql count instances of substring, then order by
negative_passages.docid: 50971
negative_passages.text: Select most recent row by some other column