Select Query

Select:- This query is used to view the data from the table.
Syntax:- 1) select * from table name
               2) select col-name,col-name,--- from tablename
               3) select * from tablename where condition
               4) Select * from tablename order by col-name [desc]
               5) Select distinct col-name from tablename
               6) Select distinct * from tablename
Ex:-           1) Select * from vision;
                  2) Select  eno,sal from vision;
                  3) Select * from vision where sal >2000;
                  4) Select * from vision order by na;
                  5) select * from vision order by na desc;
                  6) select distinct eno from vision;
                  7) select distinct * from vision;
                  8) select * from tab;

For
Online Classes

Contact Us: +919885348743