Lesson 4.5 · Pro
Make your own test data
Build a few rows by hand to test a query on an edge case, without touching any table.
In this lesson
- A VALUES list in a CTE
- Stack rows with UNION ALL
- A temporary table
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.