SQL Tutorials | 03. SQL Select

Question 1

What is the SELECT statement used for in SQL?

Answer 1

The SELECT statement is used to select data from a database.

Question 2

What is the syntax for the following?

SELECT column1, column2, …
FROM table_name;

Answer 2

Here, column1, column2, … are the field names of the table you want to select data from.

The table_name represents the name of the table you want to select data from.

Question 3

What do you do if you want to return all columns without specifying every column name?

Answer 3

If you want to return all columns, without specifying every column name, you can use the SELECT * syntax:

Example
SELECT * FROM Customers;