Learn
Practice
Newsletter
Resources
F
Toggle theme
0
F
Toggle theme
0
Toggle menu
SQL Gotchas and Tricky Behavior
Last Updated: April 13, 2026
Ashish Pratap Singh
9 min read
Get Premium
Subscribe to unlock full access to all premium content
Subscribe Now
Reading Progress
0%
On this page
Sample Data
NULL Arithmetic and Comparisons
NOT IN with NULLs
COUNT(*) vs COUNT(column)
Integer Division Truncation
BETWEEN and Timestamp Boundaries
Alias Scope and Execution Order
GROUP BY and Non-Aggregated Columns
UNION vs UNION ALL
Window Function Frame Defaults
String Comparison Surprises
ORDER BY in Subqueries
Implicit Type Coercion
Vote/Request Content
Aa
Notes
Star
Complete
Ask AI
Star Schema and Snow...
Notes
Star
Complete
Ask AI
Top-N per Group
