CASE is SQLs answer to other programming languages IF-ELSE statement. If you need to test a condition and return a value CASE is the expression you need.
Tag: queries
Posts on SQL databases queries – beginner friendly posts on joins, indexes, CTEs, and making tweaks to help things run faster.
Categories
Why You Need SQL Window Functions (pt 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.
Categories
Why You Need SQL Window Functions (pt 1)
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
Categories
Bite-Sized Videos For Beginners
Each of these Videos For Beginners is just long enough to get you started, with room to dive into the topic when you feel ready.
Categories
All About SQL Aggregate Functions
Time for some fun with SQL aggregate functions, and Mariah Carey
Categories
6 Ways to Search With System Tables
Your database doesn’t just contain your data. It also contains data about your data.
Categories
10 Ways to Tweak Slow SQL Queries
Before you rage quit or call in your DBA, check these things aren’t slowing down your SQL query. A few tweaks could be all you need to get things working.
Categories
Have You VACUUMed Your Tables Lately?
A high-level overview of why your DBA needs to VACUUM your tables
Categories
Why a Database Is Like a Dance Class
This week I got to thinking, a ballet class is a good way to describe database concepts.
