What is the difference between CROSS JOIN and INNER JOIN in SQL?
Let's understand the difference between CROSS JOIN and INNER JOIN with example
Cookbook tutorials
28 tutorials tagged Cookbook on Machine Learning Plus, newest first. Most of them belong to the SQL category.
How to get a list of dates between two dates in SQL?
Let's see how to get a list of dates between two dates in SQL using an example. We will explore alternate solutions as well.
How to get records from one table that does not exist in another?
How to get records from one table that does not exist in another?
How to exclude a column using select * except column?
How to exclude a column using select * except column in SQL? Let's also see some work arounds.
How to access the “previous row” value in a SELECT statement in SQL?
Let's see how to access the 'previous row' value in a SELECT statement in SQL?
What is the difference between UNION and UNION ALL in SQL?
Let's understand the difference between UNION and UNION ALL with an example
How to use GROUP BY to concatenate strings in MySQL and SQL Server?
How to use GROUP BY to concatenate strings in MySQL and SQL Server?
How to find duplicate values in SQL Table?
Let's see how to find duplicate values in an SQL table.
How to return results only if value exists in SQL?
You have a table with a column where some rows contain NULL values or empty strings. You want to retrieve rows where this column has a value (i.e...
How to get top n results in each ‘group by’ group in SQL?
Let's see how to get top n results in each 'group by' group in SQL. You have a table with multiple records. For each distinct value in each 'group...
How to concatenate multiple rows into one field in MySQL?
Let's see how to concatenate multiple rows into one field in MySQL?
What is the difference between INNER JOIN, OUTER JOIN and FULL OUTER JOIN?
Understand the difference between INNER JOIN, OUTER JOIN and FULL OUTER JOIN with examples and compare the results.
How to select a random row using SQL?
Let's see how to select a random row from large tables efficiently using SQL
How to randomly select rows from a large table in MySQL super fast?
Let's see how to randomly select rows from a large table quick and efficiently in SQL
How to escape a single quote in SQL Server?
Let's look at how to escape a single quote in SQL Server, with a solution that is also reproducible in MySQL
How to efficiently convert rows to columns in SQL?
Learn how to efficiently convert rows to columns in SQL using PIVOT and CASE statements. Includes example problem, input table, and working solutions.
How to split values to multiple rows in SQL?
Let's see how to split values to multiple rows in SQL with an example problem and working solution.
How to remove duplicate rows in MySQL?
Given a table in MySQL, how do you remove duplicate rows? Let's see how to solve this with an example and solutions.
How to insert into a table or update if exists in MySQL?
Learn how to insert into a table or update if exists in MySQL and SQL Server. You need to calculate a running total in SQL Server and provide a...
How to get the rows which have the max value for a column for each group in another column in SQL?
Learn how to get the rows which have the max value for a column for each group in another column
How to do a FULL OUTER JOIN in MySQL?
Let's understand how to do a FULL OUTER JOIN in MySQL
How to calculate running total in SQL Server?
Let's see how to calculate running total in SQL Server
How to switch rows and columns in SQL?
How to switch rows and columns in SQL? Let's transpose so the rows become columns and columns as rows.
How to retrieve the last record in each group in SQL?
How to retrieve the last record in each group in SQL: the problem, the input table, the desired output and three solutions, each with an explanation...
How to get the top 1 row of each group in SQL?
How to get the top 1 row of each group in SQL: the problem, the input table, the desired output and three solutions, each with an explanation of how...
How to transpose columns to rows in SQL?
Let's see how to transpose columns to rows in SQL. That is, how to reshape the table so that certain columns of a table are moved to rows.
How to select only rows with max value on a column?
How to select only rows with max value on a column for each distinct value in another categorical column in MySQL?
How to select first row in each ‘Group By’ group?
How to select first row in each 'Group By' group? Let's understand with example problem and solutions.