Clauses Of SQL Lesson 02

01.Select

This is to specify  the columns needed  for  Output.

The column names that follow the select keyword determine which columns will be returned in the results. You can select as many column names that you'd like, or you can use a "*" to select all columns.

example-(a) select Sname , Marks
            (b) select *

02.From

specifies the table that will be queried to retrieve the desired results.

example-(a) from Student
            (b) From EMP

03.Where

Specifies the Conditional creative a that applies to data.

example-(a) where marks>=50
            (b) where SName='Jone'

Conditional selections used in the where clause:

=	Equal
>	Greater than
<	Less than
>=	Greater than or equal
<=	Less than or equal
<>	Not equal to