SELECT Statement

The SELECT statement is used to read data from a table in SQL. It's one of the most commonly used commands.

Syntax

SELECT column1, column2, ... FROM table_name;

To read all columns, you can use * (asterisk)

SELECT * FROM employees;

---

Examples

Read all data

SELECT * FROM employees;

Read one column

SELECT age FROM employees;

Read specific columns

SELECT name, department FROM employees;

---

Now that you’ve got the basics of how to use the SELECT command, proceed with the problems and solve them!