Most Asked Data Engineer SQL Interview Question | Rank and Dense_Rank Without Window Functions

In this video we will solve a very commonly asked SQL interview question where you need to derive rank and dense rank output without using SQL window functions. -- create CREATE TABLE tbl ( id int, salary int ); -- insert INSERT INTO tbl VALUES (1,100),(2,200),(3,200),(4,400),(5,500),(6,500),(7,600); Zero to hero(Advance) SQL Aggregation:    • All About SQL Aggregations | SQL Advance |...   Most Asked Join Based Interview Question:    • Most Asked SQL JOIN based Interview Questi...   Solving 4 Trick SQL problems:    • Solving 4 Tricky SQL Problems   Data Analyst Spotify Case Study:    • Data Analyst Spotify Case Study | SQL Inte...   Top 10 SQL interview Questions:    • Top 10 SQL interview Questions and Answers...   Interview Question based on FULL OUTER JOIN:    • SQL Interview Question Based on Full Outer...   Playlist to master SQL :    • Complex SQL Questions for Interview Prepar...   Rank, Dense_Rank and Row_Number:    • RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...   #sql #dataengineer