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