Execution Order and Permissible Columns in SQL Clauses – I

The secret sauce is to know the order of execution of SQL clauses and columns permissible on them. If you know the A, B, C of SQL, you would be familiar with its clauses and functions, and how to use them. However, do you still find yourself persistently running into syntactical errors when trying to construct a query? …

Much Ado About Nothing – NULL Handling

In SQL's Three Valued Logic, NULL is the 'Unknown'. This is actually a pretty cool, and simple, concept which leads to a lot of confusion in implementation. Here is a compilation of what I have learned about NULL handling in code.