Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in MS SQL Server

Evaluation Order and Common Problems
Window functions and GROUP BY
Summary and Review

Instruction

The GROUP BY clause is also calculated before window functions. This means that we can't group by the values obtained with window functions. Let's check that.

Exercise

Try to run the template query. The idea is as follows: we want to divide auctions into four equal groups (quartiles) based on the number of views and show the minimal and maximal value for each group. Will this query work out?

When you're done, click I'm done. Next exercise to continue.