query: Select First Row of Every Group in sql
positive_passages.docid: 2789
positive_passages.text: Fetch the row which has the Max value for a column
negative_passages.docid: 9045
negative_passages.text: Get top results for each group (in Oracle)
negative_passages.docid: 30078
negative_passages.text: How do I perform a GROUP BY on an aliased column in MS-SQL Server?
negative_passages.docid: 65215
negative_passages.text: mysql select from n last rows
negative_passages.docid: 100486
negative_passages.text: How to select unique records by SQL
negative_passages.docid: 148923
negative_passages.text: Oracle SELECT TOP 10 records
negative_passages.docid: 109259
negative_passages.text: mysql select distinct rows into a comma delimited list column
negative_passages.docid: 62300
negative_passages.text: Mysql count instances of substring, then order by
negative_passages.docid: 150
negative_passages.text: how to select first N rows from a table in T-SQL?
negative_passages.docid: 66956
negative_passages.text: Get most common value for each value of another column in SQL
negative_passages.docid: 69755
negative_passages.text: SELECT only latest record of an ID from given rows
negative_passages.docid: 38452
negative_passages.text: SQL Not A Single Group Group Function
negative_passages.docid: 93921
negative_passages.text: Select groups based on number of unique / distinct values
negative_passages.docid: 50971
negative_passages.text: Select most recent row by some other column
negative_passages.docid: 60982
negative_passages.text: Group where every element is order 2
negative_passages.docid: 127084
negative_passages.text: Returning the 'last' row of each 'group by' in MySQL
negative_passages.docid: 16740
negative_passages.text: SQL Selecting "Window" Around Particular Row