Database Essentials - Writing Advanced SQL Queries - Analytic Functions - Ranking
Let us see how we can assign ranks using different rank functions.
1.If we have to assign ranks globally, we just need to specify ORDER BY
2.If we have to assign ranks with in a key then we need to specify PARTITION BY and then ORDER BY.
3.By default ORDER BY will sort the data in ascending order. We can change the order by passing DESC after order by.
4.We have 3 main functions to assign ranks - rank, dense_rank and row_number. We will see the differences between the 3 in a moment.
🔵Click below to get access to the course with one month lab access for "Data Engineering Essentials Hands-on - SQL, Python and Spark" -
👉🏼🔗https://www.udemy.com/course/data-eng...
▶️Link for complete playlist - • Data Engineering Essentials using Spa...
▶️Link for current playlist - • Section 011 - Database Essentials usi...
=============================================
More top rated #DataEngineering Courses from #itversity 👇🏻
_____________________________________________________
🟢Data Engineering using AWS Analytics Services
👉🏼🔗https://www.udemy.com/course/data-eng...
🟢Data Engineering using Databricks features on AWS and Azure
👉🏼🔗https://www.udemy.com/course/data-eng...
🟢Data Engineering using Kafka and Spark Structured Streaming (NEW)
👉🏼🔗https://www.udemy.com/course/data-eng...
==============================================
For quick itversity updates, subscribe to our newsletter or follow us on social platforms.
* Newsletter: http://notifyme.itversity.com
* LinkedIn: / itversity
* Facebook: / itversity
* Twitter: / itversity
* Instagram: / itversity
* YouTube: / itversityin
#Spark #Python #DataEngineeringEssentials #SQL #BigData
🟡Join this channel to get access to perks:
/ @itversity
Watch video Database Essentials - Writing Advanced SQL Queries - Analytic Functions - Ranking online without registration, duration hours minute second in high quality. This video was added by user itversity 19 December 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 153 once and liked it 2 people.