SQL Server - SELECT Statement

In SQL Server, the SELECT statement is used to retrieve rows/columns data from one or more existing tables. It follows the SQL (Structured Query Language) standards.

Syntax:

SELECT column1, column2,...columnN FROM table_name

Select All Columns

The * operator represents all the columns of a table. So, you don't need to specify each column name in the SELECT query to get data from all the columns.

SQL Script: Select Query

SELECT * FROM Employee;

The above query returns all the rows and columns data from the Employee table, as shown below.