DISPLAy

SELECT Ename AS name,Job AS job,Sal AS salary,Deptno AS department_no FROM emp;
SELECT Ename AS employee FROM emp WHERE Sal>2000;
SELECT Ename AS not_sales_or_clerk FROM emp WHERE (Job!='Salesman' AND Job!='Clerk');
SELECT Ename FROM emp WHERE Ename LIKE "S%";
SELECT Ename AS Name,Sal AS Salary FROM Emp WHERE Sal<Comm;
SELECT Ename AS Employee, Hiredate AS Hired_On FROM Emp WHERE Hiredate>'1982-01-01';
SELECT Ename,Job FROM Emp WHERE Deptno=10 OR Deptno=20;
SELECT Ename AS Em_with_manager,Job,Sal FROM Emp WHERE Mgr!="";
SELECT Ename AS name,Comm,Sal*12 AS annual_sal FROM Emp WHERE sal>Comm ORDER BY sal DESC;