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;
***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
Post a Comment