Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement