When to Use a Subquery in SQL

finally cleared all the doubts in mind and got to know the mistake i was making!!!! Thank you for this video, amazing!

Thank you for helping me finally getting this. The way you broke it down made it so much easier to understand. Thanks again!

Select product_name from products where price > avg(price).

Could you please confirm that can we write like this to find all the products having price greater than avg if products

Thank you!

Thank you sir.

The tips on breaking it down into simple steps and then bringing it all together really helps me a lot! Thank you ❤

This is great!! for the longest time, I was looking a logical explanation for subqueries

been traumatized by how complicated subquery is until I found your video. Very clear, straightforward and most importantly you explain such complicated query easily, that is indeed helpful, thanks!

Hi. Are you left handed? Just curious.

Thank you!

You are the only person that has clearly explained why and how a subquery is used. I couldn't figure out what the benefits would be. Thank you!

So well explained❤

Hello, I got a question.
I'm building a system for my organisation and this is what they do. They sell products which have varying prices depending on quantity. For example prestige 1kg is 130 but prestige box 10kg is 1,050. Please help me on how to create a database that can help with variations. Thanks

Hey there, I've got a question: I got a signals table with 2 columns (ParameterID & Time). Everytime a Parameter gets updated, it gets a new timestamp, so there are a lot of database row entries with the same ParameterID and a different timestamp. I want to query the latest timestamp of 3 specific ParameterIDs (33200, 33201, 33202). How can I achieve that in Microsoft SQL? Thanks for your help!

Thank you

thanks man it really helped

I was confused why to use subquery when we can achieve same result set from joins. now it is clear

Clear explanation

hi thank you for your video, can i ask why is a subquery need in this practice solution:
SELECT
emp_no,
(SELECT
MIN(dept_no)
FROM
dept_emp de
WHERE
e.emp_no = de.emp_no) dept_no,
FROM
employees e;

Was wondering why I cannot use join like this instead:
SELECT e.emp_no,
MIN (de.dept_no) as dept_no,
FROM employees e
JOIN dept_emp de ON e.emp_no = de.emp_no;

Your videos are extremely helpful. Clean and clear. Thanks for the content, waiting for more SQL videos!

hello. could u please cover some topics of sql that are required for data science like window functions. These topics were not present in your udemy course. please it would be of great help