I am trying to figure out the over clause. I ran across this video and I love your style of presenting your searches. The first chance I get, I will use it.
I'm not sure I understand your question, but... The ORDER BY in the OVER clause has a different purpose than the ORDER BY for the whole SELECT query. The ORDER BY in the OVER is describing how to calculate RANK/ROW_NUMBER/DENSE_RANK. The ORDER BY at the end of the SELECT statement describes how to order the *results*.
![กี่หมื่นฟ้า | Your Sky Series EP.1 [1/4]](http://i.ytimg.com/vi/vLGjxFL6U_I/mqdefault.jpg)
Extremely well put explanation, Loved it Doug!
I was missing out on this. Thank you so much for this explanation
Amazing explanation of the concepts. Thanks lot.
Glad you liked it!
This video really helped me understand rank. I noticed your TH-cam channel is really quiet. I hope you keep making videos 😄
Great way of illustration , Thanks
Really well explained, thanks Doug!
I am trying to figure out the over clause. I ran across this video and I love your style of presenting your searches. The first chance I get, I will use it.
Very helpful, and good pacing on the presentation
Now I get it! Thank you so much!
It's very clear, thank you!
VV.good explanation.
You made the Rank() easy as main()
nicely explained!
hi
the order by clause sometimes goes a total running count instead of just ordering it like rank in your case why is that?
I'm not sure I understand your question, but... The ORDER BY in the OVER clause has a different purpose than the ORDER BY for the whole SELECT query. The ORDER BY in the OVER is describing how to calculate RANK/ROW_NUMBER/DENSE_RANK. The ORDER BY at the end of the SELECT statement describes how to order the *results*.
@@DatabasebyDoug when you use sum it does a running count instead of ordering it
GOOD THINK
Hi Doug. Does the same apply fo MySQL? Thanks.
How to find the latest record for each case id in a table