No Subquery SQL Puzzle

Oracle SQL Puzzle:
Find top paid employees from every department without using sub-queries, in-line views, and common table expressions.
This is a logical continuation of the following video:    • No Function SQL Puzzle  

If you find this video useful, please press the LIKE button and subscribe.

Related Resources:

My Blog:
sqlpatterns.wordpress.com/

My Oracle Group on Facebook:

Also, you may want to join my Oracle group on Facebook: www.facebook.com/groups/sqlpatterns/

Suggested Reading:

Would you like to read about many more tricks and puzzles? For more clever tricks and cool techniques check my book: www.amazon.com/Oracle-SQL-Tricks-Workarounds-Excel…