SQL Test Query : filtering data other than dept. no 10
SELECT * FROM emp
  WHERE sal NOT IN
  (SELECT sal FROM emp
  WHERE deptno = 10)
Each DB has own way of reporting results, may use asc or desc operator to make the results look alike.
Oracle :


PostgreSQL