SQL Basics

MySQL how to split and/or transform a string

In this article you can see how to split strings

MySQL 8 how to select day, month and year from date

Or how to format the date into different output templates.

Count words and phrases in a column MySQL/SQL

In this post: * MySQL Count words in a column per

MySQL select min and max length of all table columns

If you want to query min and max length of

mysql select N max values per group

In this post: * Get N numbers per group * Get N

Group by and string concatenation in Oracle and MySQL

It's a common operation in DB to have

MySQL How to find highest and lowest value

If you want to find the highest or the lowest

SQL Count not null values in every table column

In this post: * SQL count null and not null values