SQL: string matching, ranking and partitioning

{ databases, sql } // 30.04.2014

SQL snippets: entries with different values on the same attribute

{ databases, sql } // 11.03.2014

SQL: dealing with NULLs and Coalesce

{ databases, sql } // 20.02.2014

SQL: Join, Semi Join, Left Join and ON vs WHERE clauses

{ databases, sql } // 17.02.2014

SQLite and Python basic syntax

{ databases, python, sql } // 26.01.2014