Google SQL Interview Question | Step By Step Solution

No video

Google SQL Interview Question | Step By Step Solution

Рет қаралды 11,128

Күн бұрын

In this video, we are going to solve SQL questions asked on Google for Data Analyst, Data Engineer, and Data Science positions.
Practice more questions here (Interview Query) - bit.ly/3w41nCJ
Join Data With Darshil Discord Server: / discord
👦🏻 My Linkedin - / darshil-parmar
📷 Instagram - / darshilparmarr
🎯Twitter - / parmardarshil07
🌟 Please leave a LIKE ❤️ and SUBSCRIBE for more AMAZING content! 🌟
3 Books You Should Read
📈Principles: Life and Work: amzn.to/3HQJDyP
👀Deep Work: amzn.to/3IParkk
💼Rework: amzn.to/3HW981O
Tech I use every day
💻MacBook Pro M1: amzn.to/3CiFVwC
📺LG 22 Inch Monitor: amzn.to/3zk0Dts
🎥Sony ZV1: amzn.to/3hRpSMJ
🎙Maono AU-A04: amzn.to/3Bnu53n
⽴Tripod Stand: amzn.to/3tA7hu7
🔅Osaka Ring Light and Stand: amzn.to/3MtLAEG
🎧Sony WH-1000XM4 Headphone: amzn.to/3sM4sXS
🖱Zebronics Zeb-War Keyboard and Mouse: amzn.to/3zeF1yq
💺CELLBELL C104 Office Chair: amzn.to/3IRpiL2
👉Data Engineering Complete Roadmap: • Data Engineer Complete...
👉Data Engineering Project Series: • Data Engineering Proje...
👉Become Full-Time Freelancer: • Best Freelancer Series...
👉Data With Darshil Podcast: • Podcast Series - Data ...
✨ Tags ✨
google interview question, google SQL interview, how to prepare for data science interview, data engineer interview question, data analyst SQL question
✨ Hashtags ✨
#faang #inteview #sql

Пікірлер: 58

@DarshilParmar 2 жыл бұрын

If you want more videos like this then let me know and don't forget to hit that LIKE button :D

@sandeepgaur98223 2 жыл бұрын

Yes, keep up the good work!!!

@anika7277 Жыл бұрын

Darshil … good video content and great explanation….I have a question….Is the syntax you typed for sql server OR Oracle DB???

@rabindrajaiswal5329 2 жыл бұрын

It's so easier to learn SQL from your video the way you explain step wise. In other videos, people try to solve question themselve but you try to solve exactly like how someone learning sql would do. Highly appreciated.

@surojit6315 2 жыл бұрын

Create this type of SQL interview ques video more👍

@DarshilParmar 2 жыл бұрын

I’ll work on these videos

@SandipTiwari-lr8hf Ай бұрын

This is the best video I have ever seen

@Ronak-Data-Engineer 2 жыл бұрын

Please create a complete playlist for all top most SQL Interview questions generally asked in most of product based, this video is very helpful 😊

@DarshilParmar 2 жыл бұрын

Yes I’ll try my best to create this

@sanjeevkumar-iw2lz 2 жыл бұрын

@@DarshilParmar Yes, please create playlist of sql questions, that will be unique, i am not finding any such playlist on YT

@sandeepgaur98223 2 жыл бұрын

Hi. I think dense_rank() should be used instead of rank(). Rank() function skips the rank when there are duplicate values. So assuming if engineering department has the salary as 8000, 8000, 8000, 7000, 6000, 5000. The rank function will only give the employee output as 8000,8000,8000 (For the top 3 salaries). Whereas dense_rank will give the employee info output for the salary of 8000, 7000,6000. (Total 5 Rows of output)

@DarshilParmar 2 жыл бұрын

Logic does look correct but question says top 3 employee salary to be returned, if top 3 employee salary has 8000 and those should be printed because 7000, 6000 does not come If question said print top 3 different salary for each department then we can use this and get distinct value for top 3 different

@sandeepgaur98223 2 жыл бұрын

@@DarshilParmar I read the question again, and here is my thought on that: Question is not clear. It doesn't specify if the duplicate should be allowed. So if we generalize it to a real life scenario on school ranking... then each student who gets the same marks are assigned with the same rank. But I do get your point as your query passed all the test cases and your assumption worked in this question. It was nice connecting to you. Thanks!

@krishnavasani26 3 ай бұрын

@DarshilParmar, for the case that you mentioned where top 3 salaries has same salary of 8000, we should use row_number() instead of rank(). Any thoughts?

@ssj4vrn Жыл бұрын

Can use qualify row_number() over (partition by department_id order by salary desc)

@user-zl4es9jc9w 2 ай бұрын

Very helpful

@sandeepnegi5021 2 жыл бұрын

This is best video i have ever seen.

@shashankemani1609 2 жыл бұрын

absotuley amazing. Please do come up with more such complex problems and explain us.

@DarshilParmar 2 жыл бұрын

I will try my best

@ykmohan5732 2 жыл бұрын

This was amazing.. keep doing this type of videos

@DarshilParmar 2 жыл бұрын

Thank you! Will do!

@manikanta9160 2 жыл бұрын

Great

@tejasborkar5917 2 жыл бұрын

Hey darshi , I love the video ..... Before your video i see some other youtubers video the solve the problem but they didn't explain it well😓🥲. But you explain it in such a easy way 😁😍 please make this type of videos more 🥺. Can you tell us which website u use for this 🤔can we practice there this type of questions?

@DarshilParmar 2 жыл бұрын

I used InterviewQuery for this, I have added link in description if you want to practice more

@tejasborkar5917 2 жыл бұрын

@@DarshilParmar ok thanks

@ItsPureLuck27 2 жыл бұрын

Recently came across your content and it really is super helpful and amazing Darshil! As someone who is looking to get into DE, do you feel we would be ready for an entry level position after completing DataQuests track? I really like the text based content rather than video

@DarshilParmar 2 жыл бұрын

Thank you Matthew I'd say try it by yourself whatever is comfortable, I also read books sometimes to learn things because I find it more insightful so if you like text based content, try it. Worst that can happen is you will learn something new

@aman6646 2 жыл бұрын

Great content , looking forward to see more such e.g for Amazon

@DarshilParmar 2 жыл бұрын

Coming soon!

@navejpathan 2 жыл бұрын

Hi Darshil, we could use dense_rank() to avoid skipped rank. Right? According to me dense_rank() is more appropriate.

@DarshilParmar 2 жыл бұрын

Question says, highest top 3 employees salary by department, if we use dense rank and and if we have salary duplicates then we might not get expected output Your assumption is correct and if question said something like "Find top the different salary by department" then we could have use dense_rank()

@dev_manish 2 жыл бұрын

We need more video like this 👍

@DarshilParmar 2 жыл бұрын

I’ll try my best to work on these

@georgejetson9801 2 жыл бұрын

This is very good detailed explanation.

@DarshilParmar 2 жыл бұрын

Glad it was helpful!

@diptasundarsahoo6728 2 жыл бұрын

Why you use cte??using alias table we can do

@nikhil09090 Жыл бұрын

Hi Darshil Bhai please tell me how to build logical thinking for writing this kind of questions in SQL. waiting for reply...

@DarshilParmar Жыл бұрын

Practice practice practice

@VaibhavShewale 2 жыл бұрын

okay, that was amazing

@DarshilParmar 2 жыл бұрын

Thank you vaibhav

@karthikbs8749 2 жыл бұрын

Cant we use GROUP BY department and then get the top 3 values by LIMIT 3?

@DarshilParmar 2 жыл бұрын

If you use limit 3, it will only return 3 rows, we want to return 3 rows for each department Try writing a query and executing it

@karthikbs8749 2 жыл бұрын

@@DarshilParmar Thank you

@yasarperiyar7771 2 жыл бұрын

Great work, man

@DarshilParmar 2 жыл бұрын

Appreciate it!

@as-youtuber6215 2 жыл бұрын

Wow Amazing content man

@DarshilParmar 2 жыл бұрын

Appreciate it!

@mohammadabbas1623 2 жыл бұрын

Ur helping alot

@DarshilParmar 2 жыл бұрын

Thank you

@anshumanupadhyay4938 2 жыл бұрын

More such videos, bro.

@DarshilParmar 2 жыл бұрын

More to come!

@kk-ud6ue 2 жыл бұрын

Good one

@DarshilParmar 2 жыл бұрын

Thank you! Cheers!

@abhishekchaturvedi5264 2 жыл бұрын

We can also use subquery instead of cte right?

@DarshilParmar 2 жыл бұрын

Yes, you can

@amankashyap9602 2 жыл бұрын

Sir tell the best sites to practice SQL questions

@DarshilParmar 2 жыл бұрын

You can use InterviewQuery, I have added link on description

@amankashyap9602 2 жыл бұрын

Thank you sir 😀