SQL Test Query : filtering data other than dept. no 10SELECT * 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
|