Puzzle of the Week #15:
Find all the year based intervals from 1975 up to now when the company did not hire employees. Use a single SELECT statement against emp table.
years ------------ 1975 - 1979 1983 - 1986 1988 - 2016
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.
My Oracle Group on Facebook:
If you like this post, you may want to join my new Oracle group on Facebook: https://www.facebook.com/groups/sqlpatterns/
Would you like to read about many more tricks and puzzles?
For more tricks and cool techniques check my book “Oracle SQL Tricks and Workarounds” for instructions.