Example Databases and Tables
Searched CASE in SELECT (Matches a boolean expression)
Use CASE to COUNT the number of rows in a column match a condition.
Use ORDER BY with TOP to return the top x rows based on a column's value
USE GROUP BY to COUNT the number of rows for each unique entry in a given column
Sorting by column number (instead of name)
New York, NY, United States
Cheif of Staff and VP of People, Ops, & Partnerships at Process.st
Former EVP of Culture and Experience and General Manger of Stack Overflow.
Griffin and Maeve's dad.
Pretty much always
to be helpful. If I'm not
, just let me know. (Okay, so maybe I wasn't trying that hard in
. But usually.)
SUPPORT & PARTNERS
Advertise with us
Get monthly updates about new articles, cheatsheets, and tricks.