SQL Window Functions Explained #2 | percent_rank cume_dist ntile | Interview Questions with Answers

preview_player
Показать описание
Hi everyone, hope you are doing fine. In this video I have discussed SQL Window Functions. In part 2 you will get to know the ranking functions including percent_rank() cume_dist() ntile().

Data & Notebook link -

SQL Window Functions: row_number(), rank(), dense_rank()

SQL Join Interview Questions & Answers
------------------------------------------------------------------------

Previous PySpark interview Questions Video:
--------------------------------------------------------------------------
EY Pyspark Interview Question

Pyspark UDF Foreach Questions

RDD Operations map, flatMap, reduce, reduceByKey

Previous interview experience videos
---------------------------------------------------------------
Walmart Data Engineer Interview Experience

EY Data Engineer Interview Experience

Deloitte Data Engineer Interview Experience

Data Engineering Interview Experience Playlist

Song: Lofi Beat Chill
Music by ALEX TEHNIK from Pixabay

Leave a like if you find this video helpful.

#dataengineering #interviewexperience #sql
Рекомендации по теме
Комментарии
Автор

Hi
I have just started to learn SQL. Can you please explain if there is a syntax difference in MS SQL server and Databricks?

Also can we know if there are any upcoming videos on SQL projects

coopscoops
welcome to shbcf.ru