1 / 8 · Book 15 · Your First SELECT -- Reading the Source of Truth · drill: interview Q&A⊞ allnext →Get the book →
1.2The Basic SELECT Statement
The SELECT statement retrieves data from one or more tables. It is the most fundamental SQL command and the one you will use most often as a QA engineer.
-- The simplest SELECT: get everything from a table
SELECT * FROM users;
-- Select specific columns (preferred for verification)
SELECT id, name, email, role, created_at
FROM users;
-- Select with a WHERE clause to find specific records
SELECT id, name, email, role, created_at
FROM users
WHERE email = 'newuser@test.com';
Pro Tip: Avoid
SELECT *in test automation code. Explicitly list the columns you need. This makes your tests resilient to schema changes -- adding a new column will not break your query.