Protected by Copyscape Web Copyright Protection Software

Search This Blog

Wednesday, December 4, 2013

SQL Lesson 7

Lesson 7:

III)  DQL/DRL

DQL means Data Querying Language. DRL means Data Retrieving Language. This is used to get the data from Data base. DQL is also called as DRL. We can use DQL Command to display data from Data base. The only one command in DQL is SELECT.

I)    SELECT

This command is used to fetch the data from data base.

Syntax: Select * from table_name;

Select col1, col2, col3 from table_name;

Ex: Select * from EMP;

Select Empno, Ename, Sal from EMP;
 
We are still Updating this site......

Lesson 1
Lesson 2
Lesson 3
Lesson 4
Lesson 5
Lesson 6