sql

 select ename,job,mgr,hiredate,sal,comn,deptno from emp where deptno=30;
select ename,empno,deptno from emp;
select ename , comn,sal from where comn>sal;
select ename,comn,sal from where comn>sal*0.06;
select * from emp where (job='MANAGER' and deptno=10) or (job='CLERK' and deptno=20);
select * from emp where (job='MANAGER' and deptno='10') or (job='CLERK' and deptno=20) or (job<>'MANAGER' and job='CLERK') and sal>=2000;
select distinct,ename,job,comn from emp where nvl(comn,0)>0;
select ename,comn from emp where nvl(comn,0)<100;
select ename,job,hiredate from emp where hiredate=last_day(hiredate)-2;
select ename,job from emp where months_between(sysdate,hiredate)/12>12;
select initcap(ename) ename,job,hiredate from emp;
select ename,job,hiredate from emp where length(ename)=5;
select ename,job from emp where ename not like '%r%';
select substr(ename,1,3)name,job,hiredate from emp;
select replace(ename,'A',a)name,job,hiredate from emp;
select ename,job,hiredate from emp where months_between(sysdate,hiredate)/12=10;
select * from emp order by ename;
select ename,to_char(hiredate,'YYYY')year,to_char(hiredate,'mm')months from emp order by months,year asc;
select ename,hiredate from emp where to_char(hiredate,'mm')='02';