Відео

Hii sir, your explanation is very good...i was stuck in symmetrical pair hackerrank question , saw many videos but after many video i found yours with clear explanation but your channel has very few videos...i am trying to enter into data analytics role...please help me and others to do so...upload more videos regularly and help us reach the goal...i am from non IT so please guide us accordingly...thanks a lot ❤

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;

Basically /* root is the one which has no parent, hence P is null leaf is the one which is not a parent, hence N not in (where P is not null) inner has to be the one which is a parent but not root, hence all parents except root */

ua-cam.com/video/qaplI-eU_eQ/v-deo.html

ua-cam.com/video/wkOTreqXUdQ/v-deo.htmlsi=YdydZU3nutF-tAKN

bro do u have any real time data engineer project with the problems faced

Find complete solution here. ua-cam.com/video/xx5QQu-yR8A/v-deo.html

Great video.pls provide a create and insert statement if possible for those who wish to try.

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.

Thanks

Great video, thank you sir!

Thank you so much for posting this. I was stuck on Hackerank for trying to figure out the solution. The way you explained it, it really helps. :)

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

Nice video, but whee is lead and Lag

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

Intersect is very smart.

very informative video and nicely explained

Nice video bro I like your videos

Very nicely explained, Handy during preparing for interviews!!Thanks and keep making such videos.

other approach (But almost similar): SELECT r.name FROM dbo.regular r FULL outer join dbo.PREMIUM p ON r.name = p.p_name WHERE p.p_name IS NULL;

Things are explained really in a simpler manner..Thanks for informative videos👍👍really helpful

Using Subquery and not in: select * from Regular_Customer rc where rc.name NOT IN (select pc.name from Premium_Customer pc); Note: Since there is only one column 'name' the * will work otherwise we can specify rc.name in the outer select. Please let me know, if this looks good.

Pls explain about recursive CTE. Thanks

Very Informative, thanks for the puzzles. One small request bro, Please do videos on Advanced Topics in SQL Server like Tunining, Indexes, Row Level Security , Data Encryption etc., Thanks

very good and informative video sir, I had got similar question in one of my sql rounds. I waa not able to answer it at that time. But now I got the concept. Thanks for this video.!!

It was of great help 👍

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

Nicely explained. Please share more videos Sir.

Good work...keep it up