Selecting row from group of row based on a column value
2789
Fetch the row which has the Max value for a column
110974
Switch id numbers of two rows in MySql
46339
How do I compare 2 rows from the same table (SQL Server)?
157366
Transpose some columns to rows using pivot with SQL
69755
SELECT only latest record of an ID from given rows
16740
SQL Selecting "Window" Around Particular Row
156303
Performing Inner Join for Multiple Columns in the Same Table
15594
Select the row with the maximum value in each group
41662
Delete all rows in a table based on another table
15850
How to select the nth row in a SQL database table?
76675
How do I add a class to a row based on the value of a field in that row?
92992
MySQL: Conditionally selecting next and previous rows
37901
Select first row in each GROUP BY group?
86298
How do I (or can I) SELECT DISTINCT on multiple columns?
100981
Select multiple rows with different criteria for each
103928
Concat the second column value if the first column value is same
29672
SQL Server dynamic PIVOT query?