SELECT column1, column2, ...
FROM table_name;

• SELECT: This keyword is used to specify the columns that you want to retrieve.
• column1, column2, ...: These are the columns you want to select data from.
• FROM: This keyword specifies the table from which you want to retrieve the data.
• table_name: This is the name of the table from which you want to retrieve the data.

Suppose we have a table named employees with columns employee_id, first_name, last_name, and salary. To retrieve the first_name and salary columns from the employees table, the SQL SELECT statement would look like this:

SELECT first_name, salary
FROM employees;

Select first_name,salary from employees where salary>50000;

SELECT first_name AS [FirstName], salary AS [Salary]
FROM employees;

SQL Server - Listing Tables : -

we can use the "SELECT" statement to retrieve information about tables in a database. We have three different commands to use with the SELECT statement to list all the tables in a database -

• sys.tables
• information_schema.tables
• sysobjects

The SYS.TABLES View

Following is the syntax to list down all the tables in SQL using the SYS.TABLES view -

SELECT * FROM SYS.TABLES;

Following is the output of the above query -

The INFORMATION_SCHEMA.TABLES View

Following is the syntax to list down all the tables in SQL using the INFORMATION_SCHEMA.TABLES view -

SELECT table_name, table_type FROM INFORMATION_SCHEMA.TABLES;

Following is the output of the above query -