SQL Quest › SQL Interview Questions › Querying Basics
Your First Query
Welcome to SQL! Write a query to see all the data in the passengers table. Select every column and limit the results to the first 10 rows. This is how every SQL journey begins.
Solve it in the browser editor →
Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect". Free accounts get 10 free challenge solves, and this can be one of them.
Schema
passengers
| passenger_id | survived | pclass | name | sex | age | sibsp | parch | fare | embarked |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 3 | Braund, Mr. Owen Harris | male | 22 | 1 | 0 | 7.25 | S |
| 2 | 1 | 1 | Cumings, Mrs. John Bradley | female | 38 | 1 | 0 | 71.28 | C |
| 3 | 1 | 3 | Heikkinen, Miss. Laina | female | 26 | 0 | 0 | 7.93 | S |
Expected output: First 10 rows with all columns
Hint
SELECT * means 'all columns'. LIMIT 10 restricts output to 10 rows.
Concepts
SELECT
Practise the topic: SQL practice questions
Read the concept: SQL tutorial
Related questions
All Failure Mode ReferenceEasy · FreeMedium Quality ProductsEasy · FreeGive the Top Performers a RaiseMedium · FreePick Your ColumnsEasy · FreeFilter with WHEREEasy · FreeComparison OperatorsEasy · Free
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test