MySQL how to split and/or transform a string In this article you can see how to split strings John D K Oct 15, 2018 2 min read
MySQL 8 how to select day, month and year from date Or how to format the date into different output templates. John D K Aug 13, 2018 2 min read
Count words and phrases in a column MySQL/SQL In this post: * MySQL Count words in a column per John D K Jun 18, 2018 2 min read
MySQL select min and max length of all table columns If you want to query min and max length of John D K Apr 24, 2018 3 min read
mysql select N max values per group In this post: * Get N numbers per group * Get N John D K Feb 28, 2018 3 min read
Group by and string concatenation in Oracle and MySQL It's a common operation in DB to have a need John D K Oct 26, 2017 1 min read
MySQL How to find highest and lowest value If you want to find the highest or the lowest John D K Sep 6, 2017 3 min read
SQL Count not null values in every table column In this post: * SQL count null and not null values John D K Aug 29, 2017 4 min read
