SQL Coding Interview Questions #2| Symmetric pairs HackerRank full solution | Data Bytes

This is a logical scenario based SQL question where you just need to apply basic SQL concepts and solve this.
This type of questions are commonly asked in almost all companies SQL interviews. So its better to prepare as many questions of this type as you can. for more such questions you can see other Videos on my channel.

👉 SQL Coding Interview Question Series 👇:-

👉 Importing excel data as table to ms sql server 👇:-

👉 Window Functions(Ranking Functions) 👇:-

👉 Window Functions(Ranking Functions) free notes 👇:-

👉 Please do like and share the video if it is helpful for you. Also please subscribe the channel and press the bell button to get notified about any new video.

👉 To get updates on more such videos and various SQL Interview experiences join the community of all SQL coders, developers, Analysts, data scientists, Data Engineers here :-

Please give your valuable feedback about the Video and do subscribe to our channel and share it with all needed ones.
Thank You !

#Data #bytes
#SQLinterviewQuestions #SQL #SymmetricPairs
#DataAnalyst #DataScientist
#DataEngineer #Amazon
#Dunzo #Flipkart #Hotstar #Myntra.....
#data #bytes #data_bytes
#data_bytes_yt
#DataBytes #SQLInterviewQuestions #DataAnalysis #SQLQueries #TechInterviews #DataSkills #DatabaseManagement #databytes #SQLOptimization #DataScience #TechTips #data #bytes

#SQLinterviewQuestions #SQL #SymmetricPairs
#DataAnalyst #DataScientist
#DataEngineer #Amazon
#Dunzo #Flipkart #Hotstar #Myntra.....
#data #bytes #data_bytes
#data_bytes_yt
#DataBytes #SQLInterviewQuestions #DataAnalysis #SQLQueries #TechInterviews #DataSkills #DatabaseManagement #SQLOptimization #DataScience #TechTips

[rahulnegi]

Thanks a lot, buddy. It was really helpful
Interesting stuff on the channel

[vivekjoshi]

How to do this without using windows function?
The question on hackerrank is filed under Advanced Joins and not Windows Functions.
I am wondering how to solve this without Windows Functions.

[vitorcastro]

Hey, can anyone explain why my MYSQL solution is wrong?

with
Functions_symmetric as
(
select Functions.y as x2, Functions.x as y2
from Functions
),
Joined_tables as
(
select Functions.x, Functions.y, Functions_symmetric.x2, Functions_symmetric.y2
from Functions inner join Functions_symmetric
on Functions.x = Functions_symmetric.y2 and Functions.y = Functions_symmetric.x2
)

select distinct x, y
from Joined_tables
where x <= y
order by x asc;

[gayatripawar]

Helpful 🙏 can u pls put some light on Bigdata, python and Machine learning interviews as well

[RB-tx]

what is " from[Function]" in your row_number statement???