How to Write Advance SQL Queries | Consecutive Empty Seats | SQL Interview Questions
Автор: Ankit Bansal
Загружено: 2022-03-30
Просмотров: 26933
Описание:
In this Video I will be solving a SQL problem with 3 different methods.
00:00 Understand the Problem
01:21 Method 1 : Lead/Lag
06:24 Method 2 : Advance Aggregation
10:55 Method 3: Using ROW_NUMBER
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN based Interview Questi...
Data Analyst Interview 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...
Script:
create table bms (seat_no int ,is_empty varchar(10));
insert into bms values
(1,'N')
,(2,'Y')
,(3,'N')
,(4,'Y')
,(5,'Y')
,(6,'Y')
,(7,'N')
,(8,'Y')
,(9,'Y')
,(10,'Y')
,(11,'Y')
,(12,'N')
,(13,'Y')
,(14,'Y');
#sql #advance #dataengineer
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
