Count words and phrases in a column MySQL/SQL
In this post: MySQL Count words in a column per row MySQL Count total number
Oracle count null and not null values in column
In this article we will post two ways of counting null and not null values
MySQL Equivalent of Oracle's SQL loader
In this post: MySQL SQL loader equivalent - LOAD DATA INFILE MySQL SQL load csv
SQL union and where clause
Sometimes there is a need of filtering result of a union of several tables. This
Group by and string concatenation in Oracle and MySQL
It's a common operation in DB to have a need of grouping and concatenating several
Nice article about 10 SQL optimisations: MySQL, Oracle, SQL Server, DB2, PostgreSQL
Recently I found a very nice article explaining in great detail how you can optimize
Oracle, MySQL - select max and return multiple values
A common problems in SQL are to find the data for the row with some
Oracle indexes - create, rebuild, select, drop
Select all indexes by status Check indexes by status by two queries from metadata of
SQL concatenate examples
Concatenation basics concatenation functions: Oracle - concat MySQL - concat MSSQL - concat PostgreeSQL -