Ex 2

SELECT Ename,Job,Sal,DeptNo FROM Emp;
SELECT Ename AS Employee  FROM Emp WHERE Sal>2000;
SELECT Ename FROM Emp WHERE Job!="Salesman" AND Job!="Clerk" ORDER BY Ename;
SELECT Ename FROM Emp WHERE Ename LIKE "S%";
SELECT Ename AS Name,Sal AS Salary FROM Emp WHERE Sal<Comm;
SELECT Ename,Hiredate FROM Emp WHERE Hiredate LIKE "1980-%";
SELECT Ename,Job,DeptNo FROM Emp WHERE DeptNo=10 OR DeptNo=20 ORDER BY Ename;
SELECT Ename,Job,Sal,Mgr FROM Emp WHERE Mgr>0;
SELECT Ename,Sal*12 AS Annual_Sal,Comm FROM Emp WHERE Job="Salesman" AND Sal>Comm ORDER BY Sal;