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?
MySQL tutorials
12 tutorials tagged MySQL on Machine Learning Plus, newest first. Most of them belong to the SQL category.
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?
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 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 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 do a FULL OUTER JOIN in MySQL?
Let's understand how to do a FULL OUTER JOIN in MySQL
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...
SQL Tutorial – A Simple and Intuitive Guide to the Structured Query Language
SQL, short for Structured Query Language is a programming language used to communicate with databases and do various types of Data wrangling...