TRICKIER SQL INTERVIEW question based on SYMMETRIC PAIRS
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- **********************************************************************
Complete SQL Query Script for the video is available at:
houseoftechcon...
In the Video we are going to discuss the step by step solution of SQL question asked in technical interview
This video covers the concept of UNION, GROUP BY, WHERE, INNER JOIN, HAVING and ORDER BY clause in SQL.
**********************************************************************
The video is the twenty first part of series for SQL Interview and Answers.
Entire series has step by step solution for building queries for scenarios that are asked in technical interviews.
Previous Video Links :
Scenario Microsoft: • Microsoft SQL Intervie...
Scenario The New York Times: • Microsoft SQL Intervie...
Scenario Microsoft-2: • SCENARIO based SQL INT...
Scenario Facebook: • Key question to prepar...
Scenario Facebook-2: • Scenario Based SQL INT...
Scenario Facebook-3: • SCENARIO BASED FACEBOO...
Scenario Accenture-2: • Accenture SQL Intervie...
Scenario Infosys: • Important Question to ...
**********************************************************************
#database #sql #interview #subscribe #like #data #houseofconcepts #subscribers #interview #interviewquestion #sqlserver
Playlists Link:
1) SQL Interview Questions and Answers : th-cam.com/play/PLFbjn94wCCeW0WuMg-w070dvMEOm8npQ9.html
2) Data Warehouse : th-cam.com/play/PLFbjn94wCCeWqODvODLOFHq16PqwHpRQC.html
3) Power BI - Power Query : th-cam.com/play/PLFbjn94wCCeVPWFX7d9gUKhhL96mXsUcd.html
4) Power BI - Data Modeling & DAX : th-cam.com/play/PLFbjn94wCCeUJIvCpU6lQ1RUTFhvB_CiQ.html
one of the finest ans i have ever encountered yet .thanks,if someone ask you how much clear understanding of sql do you have just show them this video ,
Thank you so much for your kind words…please keep supporting the channel🙏🏼
Finished watching
Thank you!
Very difficult n tricky
with cte as(
select *,row_number() over(order by x,y) as r from functions)
select c.x,c.y from
cte c inner join cte ct on
c.x=ct.y and c.y=ct.x and c.rct.r and c.x
select distinct a.x,a.y from
(select row_number() over (order by f.x) rnb,f.x,f.y from FunctionDetails f) a
inner join
(select row_number() over (order by f1.x) rnb, f1.x,f1.y from FunctionDetails f1)b
on concat(a.x,a.y)=concat(b.y,b.x)
and a.rnbb.rnb and a.x
correct alternate solution :)
Nice job. More of these please.
Thank you! Please stay tuned for more content like this…