Conditional logic with the CASE expression
CASE is SQL’s equivalent to IF-ELSE statements in other programming languages. This expression allows you to test a condition and return a value.
Tag: sql
Why you need SQL window functions (part 2)
SQL Server Window Functions are incredibly powerful and allow us to access a total from another row and bucket data to show top performers.
Why you need SQL window functions (part 1)
SQL window functions are incredibly powerful and allow us to see the rows in a table with a new column showing a running total, rank or moving average.
SQL aggregate functions and Mariah Carey
Aggregate functions bring your data to life.
They allow you to take a standard table and use a function or two to build metrics and answer questions about the data.
Search with system tables
Your database doesn’t just contain your data. It also contains data about your data.
A database is like a dance class
As I was having a hard time switching off from work this week, I thought: a ballet lesson would be a great way to discuss database concepts.
