All pastes #967138 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-04-02 06:31 UTC
rendered paste body
/*ECT ename
FROM EMP
WHERE com>sal;


SELECT dname
FROM DEPT
where deptno>20;


SELECT mgr
FROM EMP
WHERE sal>2800;


SELECT ename
FROM EMP
WHERE (sal>2800 OR job='MANAGER');


SELECT ename
FROM EMP 
WHERE (JOB='MANAGER' AND deptno<>30);
*/
SELECT *
FROM EMP
ORDER BY sal