SQL Basics

How do we retrieve all data from a table in a database?

Beginner⏱ 1 Minutes⭐ 100 XP

🤔 THE QUESTION

How do we retrieve all data from a table in a database?

💡 WHAT IS IT?

SELECT is used to retrieve data from tables, and FROM specifies the source table.

🎯 WHAT IS IT USED FOR?

It is the foundational query structure used in every data warehouse and transactional database.

💻 EXAMPLE

SELECT *
FROM employees;

Practice typing production-grade SQL code for SQL Basics.