In this video we will see how we can do custom sort with some particular values on top and rest based on some column value. Very important SQL trick and useful in day to day work along with interview prepration.
Most Asked Join Based Interview Question:
https://youtu.be/xR87ctOgpAE
Data Analyst Spotify Case Study:
https://youtu.be/-YdAIMjHZrM
Top 10 SQL interview Questions:
https://youtu.be/Iv9qBz-cyVA
Interview Question based on FULL OUTER JOIN:
https://youtu.be/KQfWd6V3IB8
Playlist to master SQL :
https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb
Rank, Dense_Rank and Row_Number:
https://youtu.be/xMWEVFC4FOk
Link to the dataset:
https://drive.google.com/drive/folders/1Dc81McsB4lp1JUIwssDmmOaw6Z7rBK8T?usp=sharing
#sql #dataengineer
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.