Solving Complex SQL Query from HackerRank | SQL Interview Query

preview_player
Показать описание
In this video, we will learn how to solve a complex SQL query. The SQL problem is taken from HackerRank. We shall use recursive sql to solve the given problem.

Link to HackerRank problem:

Download the scripts, dataset and solution used in this video from my blog. Link below:

Join my SQL Course:

View the course content here:

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:

✅ SQL Tutorial - Intermediate concepts:

✅ SQL Tutorial - Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ Data Analytics Career guidance:

✅ SQL Course, SQL Training Platform Recommendations:

✅ Python Tutorial:

THANK YOU,
Thoufiq
Рекомендации по теме
Комментарии
Автор

The way you explained everything in detail I subscribed immediately.

This is how SQL need to be taught

vishwanath-ts
Автор

I was struggling with the recursive queries concept u made it so easy to undestand...and with that i was able to solve the question very easily

SwethaNandyala-sflt
Автор

Hello Thoufiq,
Can you please make a video on SQL Query optimization?
What things to be considered before writing query or how we can rewrite existing query for better execution time ?
Please just consider query structure only
(Not the changes on DB side like defining correct DataTypes, Indexes etc)
Thanks a lot in advance ☺️

Anonymous-lezr
Автор

I love the way how you splitting tasks, that really make sense and helps to organise things in your head. Thank you for the video.

markobondaruk
Автор

Hi Taufiq,
Your way of explanation on how to solve complex sql problems is real good and easy to understand.

Also, i liked that you started with basic syntax of recursive cte for evryone to understand.

I will be trying to use your way of deduction in my projects going forward.
Thanks and keep going.

yogeshmishra
Автор

Great explanation and awesome practical example that distinctly illustrates the purpose of recursive sql queries!

mateuszsmendowski
Автор

I have seen many solution of this question. But finally my search comes to an end i understand each and every thing crystal clear.

alishakumari
Автор

Hello Sir I'm a new learner tumhare classes bohot ache hin sir. Mai new se start kari hun SQL and ur classes r helping me a lot to become Power BI developer need SQL mandatory hai na so I'm learning from scratch thank you so much😊 for such a beautiful classes

firdosesyed
Автор

Please solve all hackerrank problems...Lots of videos in YOu tube...but ur way of teaching makes me intresting in SQL...

rajmathichithramani
Автор

The best SQL teacher ever, awesome man, u rock too much

hilarylomotey
Автор

Another awesome content from Tofig,
Thank you so much. Clicked too much the liked button and it’s broken now. 😂😂😂😂

qurdedu
Автор

Hii sir, Actually i came across this query while practicing, but i didn't get the correct answer, Now i understood.Thank you so much sir..

dheerajlakkakula
Автор

Love your these kind of videos where you show us how to solve a complex sql query👌Thanks a lot for such amazing videos🙌🏻🙏

mohammedshahil
Автор

Thank you very much for explaining. There is one problem, when i run the solution on sample data in sql-workbench on my computer, it works fine but when i submit the same solution on hackerrank it show error

VipinSingh-gzpz
Автор

Great simplification of such a complex problem and also thank you for adding the error in hackerrank, even I faced that and was confused initially whether to consider this solution or not. But thanks for clarifying that this might be an issue with the SQL version used in hackerrank

simranagichani
Автор

Just loved it the way you explain....Plz make a video on REGEXP in Oracle DB ... Thanks Taufeeq

nehalahmad
Автор

Thank you so much.. I was looking for this from some time now. Your style of explanation is awesome. Keep up the good work.

srinivasv
Автор

I am very grateful for what you did in this video. Wish your channel grow more !

data-dynamo-guy
Автор

Wow... You made this video... I was facing problem with this question!

supriya
Автор

Also for the next query,
SELECT sub_date, hacker_id
FROM
(Select sub_date, hacker_id, ROW_NUM() OVER(partition by sub_date, hacker_id order by hacker_id)
FROM submissions)
WHERE rn = 1

ameygoesgaming