SQL SELECT Commands

The SELECT command is used to select data from a database and table.

MS-SQL SELECT Syntax:

SELECT column_1_name,column_2_name,.....  FROM table_name

or (with * means select all columns)

SELECT * FROM table_name

Example:

As you see, we have like this "Candidate" table.

The following SQL Syntax selects the "CandidateId" and "CandidateNumber" columns from the "Candidate" table:

Syntax:

SELECT CandidateId,CandidateNumber FROM CANDIDATE

Output:

Syntax:

SELECT * FROM CANDIDATE

Output: