SELECT SQL

Posted by AnithaKamatchi on Thursday, March 02, 2017 in SQL | No comments

Usage : 

Extract the data from the database

How the SELECT query works????

Consider the table "Student_List"  as shown below

Case 1:

Retrieve all the columns in the table "Student_List"

Syntax:

Select * from table <table_name>

Sample Query:

Select * from table Student_List

Result:

Case 2:

Retrieve only desired columns in the table "Student_List". Lets say (Student_ID,Student_Name) in this case

Syntax:

Select <column 1>,<column 2>...<column n> from table <table_name>

Sample Query:

Select Student_Id,Student_Name from table Student_List

Result: