IMPORTANT SQL queries

*select ename,sal from emp order by sal asc;

*select ename,sal from emp order by sal asc,ename desc;

*select ename from emp where comm is not null;

*select ename from emp where comm>sal;

*select ename from emp where comm>sal*(50/100);

*select ename,HIREDATE from emp where hiredate between to_DATE('01-01-1981','DD-MM-YYYY') and to_DATE('01-01-1982','DD-MM-YYYY');

*select ename,HIREDATE from emp WHERE TO_CHAR(HIREDATE,'MM')='02';

*select ename,HIREDATE from emp WHERE TO_CHAR(HIREDATE,'YYYY')='1981';

*SELECT DEPTNO,COUNT(*) FROM EMP GROUP BY DEPTNO;

*SELECT ENAME,SAL,SAL*.1 COMMISION FROM EMP WHERE SAL*.1 > 200;

*SELECT D.DNAME,COUNT(*) FROM EMP E, DEPT D WHERE E.DEPTNO(+) = D.DEPTNO GROUP BY D.DNAME;

*select job,count(*),sum(sal),avg(sal),max(sal),min(sal) from emp group by job;

*select deptno,count(*),sum(sal) from emp group by deptno;

*select deptno,job,count(*),sum(sal) from emp group by cube(deptno,job);

*select job,deptno,count(*),sum(sal) from emp group by rollup(job,deptno);

*select job,count(*) from emp where job in('SALESMAN','MANAGER') group by job having count(*)>=3 order by job;

*SELECT ENAME,SAL,DEPTNO,DECODE(DEPTNO,10,'TEN',20,'TWENTY','OTHER') FROM EMP;

*SELECT JOB,SUM(DECODE(DEPTNO,10,SAL)) DEPTNO10,SUM(DECODE(DEPTNO,20,SAL)) DEPTNO20,SUM(DECODE(DEPTNO,30,SAL)) DEPTNO30 FROM EMP GROUP BY JOB;

*UPDATE EMP SET COMM=DECODE(JOB,'CLERK',SAL*0.1,'SALESMAN',SAL*0.2,'MANAGER',SAL*0.3,'ANALYST',SAL*0.5,SAL*0.6);

*SELECT D.DNAME,E.ENAME FROM EMP E,DEPT D WHERE E.DEPTNO = D.DEPTNO;

*SELECT JOB,ENAME FROM EMP ORDER BY JOB;