SQL • LESSON 02

SELECT Statement

Learn how to retrieve data from a table using SELECT.

🟢 Beginner⏱ 4 Minutes⭐ 100 XP
🤔 THE QUESTION

How can we return only the employees who belong to the IT department?

💡 WHAT IS IT?

The WHERE clause filters rows based on a condition.

🎯 WHAT IS IT USED FOR?

It is used whenever you need only specific records instead of every row in a table.

💻 EXAMPLE
SELECT *
FROM employees
WHERE department = 'IT';

Mission Brief

Practice writing your first SQL SELECT query using production-style syntax.

Objectives

  • ✓ SELECT
  • ✓ FROM
  • ✓ Aliases
  • ✓ Formatting
🚀 Start Mission