SELECT QUERYS

                                             SELECT QUERYS

***UNIQUE***
SELECT UNIQUE(ENAME) FROM RAJA;
 
***COUNT***

SELECT COUNT(ENO) FROM ROCK;

***TOP***
SELECT TOP 2 * FROM ROCK;

***AS***
SELECT ENAME AS EMPOLYEENAME FROM ROCK;

***IN***
SELECT * FROM ROCK WHERE SALARY IN(1000,200);

***NULL***
SELECT ENAME FROM ROCK WHERE PLACE IS NULL;

Comments