Sunday, April 10, 2016

SQL Select Syntax

In this lesson we learn more important thing about SQL . We  learn  about SQL clause "SELECT" .SQL SELECT statement can retrieve the data from  table.

We have a table  name  "students"  where  the filed are "Id" , "FullName"," Grade", "AdmissionFee"

Now if we do a SQL query  that retrieve all student data.

SELECT * FROM  students ;

SQL Where

Where statement use to find specific data from the table.

In this SELECT query where condition find out which students name , whom are give admission fee less then 200000.

SELECT FullName 
FROM students
WHERE AdmissionFee < 200000 ;

No comments:

Post a Comment