Thank you for the nice article. I setup the environment in virtualbox and found it much easier than hyper-v.

Nice Query Paul ,

You just do not need to include the ProductId ine order by of the over clause as you're doing partions by Productid 🙂

Dwain, thanks for your...

Thnks for the great article. I have just one remark :

For Question 1 the answer is C and not A. as the answer A refers to inner query instead...

very appreciated initiative .

SELECT id, val,

ROW_NUMBER() OVER(ORDER BY val) AS rownum,

RANK() OVER(ORDER BY val) AS rnk,

DENSE_RANK() OVER(ORDER BY...