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
Смотрите видео Database Essentials - Writing Advanced SQL Queries - Analytic Functions - Ranking онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь itversity 19 Декабрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 153 раз и оно понравилось 2 людям.