The SQL Group By Clause
This is the written version of a lesson from my SQL Course, in which I introduce students to the awesome and very commonly used SQL GROUP BY clause. If you want to follow along, here is the script you can… Continue Reading
Basics
CASE expressions in Oracle SQL
CASE expressions are the standard way to implement IF … THEN … ELSE logic in SQL statements. Oracle provides the DECODE function, which does something similar and is widely used by Oracle developers, but CASE expressions are actually more flexible… Continue Reading