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:
https://sqlpatterns.wordpress.com/

My Oracle Group on Facebook:

Also, you may want to join my Oracle group on Facebook:   / sqlpatterns  

Suggested Reading:

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