You're a gem in explaining window functions(so far I checked out the SQL window functions video, will check out others soon)
@OldPick-Unix-dude-pb9jg
Жыл бұрын
Appreciate the explanation on the NTILE - used it create sample data.
@BeardedDevData
Жыл бұрын
Excellent.
@pokepoke3
4 жыл бұрын
I just started learning about window functions, and you've been the most helpful. Thank you.
@giorgosi.fovakis8810
3 жыл бұрын
Great! and nice example with CTE in the end as well
@amalal-suhaimi9810
5 жыл бұрын
Can you provide a table with the movie titles and divide them into 4 levels (first_quarter, second_quarter, third_quarter, and final_quarter) based on the quartiles (25%, 50%, 75%) of the rental duration for movies across all categories? NTILE(4) OVER (ORDER BY title ) AS standard_quartiles >>>> is it right ?
@BeardedDevData
5 жыл бұрын
In that case you will need to change the order by to be by rental duration.
@Khaled_Abdelaal
3 жыл бұрын
@BeardedDev: I have one technical question. How can I contact you, please?
@BeardedDevData
3 жыл бұрын
Hi, you can either contact me on here or email me at askbeardeddev@gmail.com
@Khaled_Abdelaal
3 жыл бұрын
@@BeardedDevData Thanks. I will drop you an email
@pabeader1941
4 жыл бұрын
I know this is an old video, but did you know that it cuts off before you complete the story about the 1 million rows of data??
@BeardedDevData
4 жыл бұрын
Yes, there was an issue with the end screen but because I had worked through all the examples it was uploaded. The story regarding the million rows actually finishes, I just explain that if you have that many rows you can divide them in to tiles then select a tile to work with.
@pabeader1941
4 жыл бұрын
@@BeardedDevData okay. I'm just used to your wind down at the end. sall gud.
Пікірлер: 13