Puzzle of the Week #6
Find all employees who is paid one of top 4 salaries in the entire company without using sub-queries and in-line views/WITH clause.
ENAME SAL ---------- ---------- KING 5000 FORD 3000 SCOTT 3000 JONES 2975 BLAKE 2850
To submit your answer (one or more!) please start following this blog and add a comment to this post.
A correct answer (and workarounds!) will be published here in a week.
If you like this post, you may want to join my new Oracle group on Facebook: https://www.facebook.com/groups/sqlpatterns/
For more tricks and cool techniques check my book “Oracle SQL Tricks and Workarounds” for instructions.