Advertisement
Saboten758

DISPLAy

Apr 9th, 2024
733
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.61 KB | None | 0 0
  1. SELECT Ename AS name,Job AS job,Sal AS salary,Deptno AS department_no FROM emp;
  2. SELECT Ename AS employee FROM emp WHERE Sal>2000;
  3. SELECT Ename AS not_sales_or_clerk FROM emp WHERE (Job!='Salesman' AND Job!='Clerk');
  4. SELECT Ename FROM emp WHERE Ename LIKE "S%";
  5. SELECT Ename AS Name,Sal AS Salary FROM Emp WHERE Sal<Comm;
  6. SELECT Ename AS Employee, Hiredate AS Hired_On FROM Emp WHERE Hiredate>'1982-01-01';
  7. SELECT Ename,Job FROM Emp WHERE Deptno=10 OR Deptno=20;
  8. SELECT Ename AS Em_with_manager,Job,Sal FROM Emp WHERE Mgr!="";
  9. SELECT Ename AS name,Comm,Sal*12 AS annual_sal FROM Emp WHERE sal>Comm ORDER BY sal DESC;
  10.  
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement