SQL SELECT Statement

30/07/2015 Gaurav Shukla
The SELECT Statement is used to fetch the data from database table. The result is stored in a result set table as shown below.

SQL SELECT Syntax

SELECT column_name1,
column_name2 
FROM table_name

Example

SELECT * FROM HR.Employee

Output

SELECT STATEMENT

In SQL SELECT Statement * (star) denotes the All. It means when we use it is showing all the columns of selected table.In Select statement column name can also be specified.
SELECT BusinessEntityID, 
LoginID, 
BirthDate, 
OrganizationLevel
From HR.Employee
Output
Modenpathshala Select
Author
Author: Gaurav Shukla
Published On: 30/07/2015
Last revised On: 03/05/2016

Share this chapter
Comments
comments powered by Disqus

Navigation

Social Media