2 min
SQL
How to do a FULL OUTER JOIN in MySQL?
Problem How to do a FULL OUTER JOIN in MySQL? Let’s create two example tables, employees and departments, and insert some data into them....
#CookBook
28 articles
2 min
3 min
SQL
How to get the rows which have the max value for a column for each group in another column in SQL?
Problem You want to find the rows that have the maximum value for a specific column within each group in another column. For example,...
2 min
SQL
How to switch rows and columns in SQL?
Problem How to switch rows and columns in SQL so that the rows and columns are interchanged? Given a table named Students with columns...
3 min
SQL
How to retrieve the last record in each group in SQL?
Problem You have a table with multiple rows of data for each group, and you want to select the last row from each group....
3 min
SQL
How to get the top 1 row of each group in SQL?
Problem From the test_scores table below, select the top 1 row in each group. For example, you have a table with data about ‘students’...
3 min
SQL
How to select first row in each ‘Group By’ group?
Problem You have a table with multiple rows of data for each group, and you want to select the first row from each group....
2 min
SQL
How to transpose columns to rows in SQL?
Problem How to transpose columns to rows in SQL? This essentially requires reshaping the table in such a way that certain columns of a...
2 min
SQL
How to select only rows with max value on a column?
Problem How to select only rows with max value on a column for each distinct value in another categorical column in MySQL? From Items...
