A Dev Gym Workout

Know the Difference: RANGE and ROWS in Window Clause


You can use both RANGE and ROWS in the analytic window clause. In this workout, Kim Berg Hansen, Dev Gym SQL Quizmaster, offers an article from his blog explaining use cases for these two options. After you finish the article, try out his quizzes on the same topic.

  • Instructor

    Kim Berg Hansen*

  • Estimated Time

    40 Minutes

  • Difficulty

    Intermediate to Advanced

Take Workout

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Exercises

Exercise Difficulty Time
ROWS versus default RANGE in analytic window clauseAdvanced15
Quiz on Difference between RANGE/ROWS WindowsIntermediate6
Quiz on Difference between RANGE/ROWS WindowsIntermediate6
Quiz on Difference between RANGE/ROWS WindowsIntermediate5
Quiz on Difference between RANGE/ROWS WindowsAdvanced7
Quiz on Difference between RANGE/ROWS WindowsAdvanced2
Take Workout
Instructor

*About Kim Berg Hansen

Danish geek. Author of 'Practical Oracle SQL' book. ORACLE ACE Director. Oracle OCE in SQL. Oracle SQL Evangelist. Oracle PL/SQL Developer. Likes to cook. Reads sci-fi. Member of Danish Beer Enthusiasts.

More from Kim Berg Hansen