***SQL CLAUSES***

        ***SQL CLAUSES***

                                             ***WHERE***
1)SELECT * FROM ROCK WHERE SALARY=1000;
2)SELECT * FROM ROCK WHERE SALARY<1000;
3)SELECT * FROM ROCK WHERE SALARY>1000;
4)SELECT * FROM ROCK WHERE SALARY<=1000;

                                             ****AND****
5)UPDATE ROCK SET ENAME='PAPU' WHERE PLACE='EEE' AND SALARY=2000;
6)SELECT ENO FROM ROCK WHERE SALARY=1000 AND ENAME='RAJA';

                                                ***OR****
7)UPDATE ROCK SET ENAME='PAPU' WHERE PLACE='EEE' OR SALARY=2000;
8)SELECT ENO FROM ROCK WHERE SALARY=1000 OR ENAME='RAJA';

                                               ***NOT***
9)SELECT ENAME FROM ROCK WHERE NOT ENAME='PRABHU';
10)SELCR SALARY FROM ROCK WHERE NOT SALARY>1000;

                                             ***AS****
11)SELECT ENAME AS EMPNAMEELIST FROM ROCK;

                                    ****ORDER BY****
12)SELECT * FROM ROCK ORDER BY ENAME;
13)SELECT ESAL FROM ROCK ORDER BY NAME;

                                  ****GROUP BY****
14)SELECT ENO,SUM(SALARY) FROM ROCK GROUP BY ENO;
15)SELECT ENAME,COUNT(ENO) FROM ROCK GROUP BY ENAME;
16)SELECT ENO,MIN(SALARY) FROM ROCK GROUP BY ENO;
17)SELECT ENO,MAX(SALARY) FROM ROCK GROUP BY ENO;

                           ****GROUP BY HAVING****
18)SELECT COUNT(ENO), SALARY FROM Customers GROUP BY SALARY
HAVING SALARY >1000;

                                     ****DESC****
19)SELECT * FROM ROCK ORDER BY ENAME DESC;
20)SELECT SALARY FROM ROCK ORDER BY ENAME DESC;

                                  ****LIKE****
21)SELECT * FROM ROCK WHERE ENAME LIKE 'P%';
22)SELECT * FROM ROCK WHERE ENAME LIKE '%U';
23)SELECT * FROM ROCK WHERE ENAME LIKE '_A%';
24)SELECT * FROM ROCK WHERE ENAME LIKE '__P%';
25)SELECT * FROM ROCK WHERE ENAME LIKE '__AB__%';

                           ***UNION&UNION ALL****
26)SELECT * FROM RAJA UNION SELECT * FROM ROCK;
27)SELECT * FROM RAJA UNION ALL SELECT * FROM ROCK;
28)SELECT ENAME FROM RAJA UNION  ALL SELECT ENAME FROM ROCK;
29)SELECT ENAME FROM RAJA UNION SELECT ENAME FROM ROCK;

                             ****IN & NOT IN****
30)SELECT ENO FROM ROCK WHERE ENAME IN('PAPU','PRABHU');
31)SELECT ENO FROM ROCK WHERE ENAME NOT IN('PAPU','PRABHU');

                            ****BETWEEN****
32)SELECT ENAME FROM ROCK WHERE SALARY BETWEEN 1000 AND 2000;