Blog items and articles

Retrieving data

Select, return or output

Open article

#SQL

SQL language subsets

Data Definition Language, Data Manipulation Language and Data Control Language

Open article

#SQL

Table labels and column aliases

Keeping your sql clean

Open article

#SQL techniques, #SQL

Inner join

Join tables when there are matching keys

Open article

#SQL joins, #SQL

Left join

Join tables when there may or may not be matching keys

Open article

#SQL joins, #SQL

Select statement projection

Don't select fields you don't need

Open article

#SQL techniques, #SQL