How to do Subqueries in SQL with Examples

Рет қаралды 165,842

4 жыл бұрын

Step-by-step tutorial shows you how to use SQL subqueries in your SELECT statement & FROM and WHERE clauses!
Queries:
1) A subquery in the SELECT statement: SELECT customerid, freight, (SELECT AVG(freight) FROM orders) FROM orders
2) A subquery in the FROM clause: SELECT shipcountry, AVG(num_orders) FROM (SELECT customerid, shipcountry, count(*) AS num_orders FROM orders GROUP BY 1,2) sub GROUP BY 1
3) A subquery in the WHERE clause: SELECT * FROM orders WHERE employeeid IN (SELECT employeeid FROM employees WHERE LOWER(firstname) LIKE '%b%')
Get the Northwind Database: • How to Load a Sample P...
Support the Channel:
1) Subscribe: www.becomingads.com/o/youtube
2) DataCamp:
3) Udacity:

Пікірлер: 177

@honeyclover5038 3 жыл бұрын

Finally, a break through. Finally, someone who explains the use of sub queries well.

@sarahemslie6105 4 жыл бұрын

This is really helpful; more so than my online course! I look forward to watching more of your videos. Thank you!

@Aaron-il5pk 3 жыл бұрын

Thank you for telling us that even when you first learned this it was complex, because holy cow! I cannot wrap my head around this. I can kind of grasp whats going on, but I think you know the confusion that goes through a noob's mind. Thank you for your tutorials! I plan on watching many more of your videos.

@dabeast0623 3 жыл бұрын

CANNOT EXPLAIN ENOUGH HOW MUCH YOU SAVED MY LIFE.

@juliakristavilladiego4425 3 жыл бұрын

Spending my Christmas binge watching your SQL tutorials haha so helpful. Thank you!!!!

@becomingADS 3 жыл бұрын

Haha, sounds like a good Christmas to me!

@Peter-cx4ir 2 жыл бұрын

Really great explanations. Easy to follow and perfect variety. Very much appreciate you posting these tutorials, they're beyond helpful. Thanks!

@jorgehernandezdominguez6574 Жыл бұрын

WOW! the way you explained that is like first doing a table to then going and making a query from that table was a breakthrough for my understanding of the concept. I really admire people who can transform concepts into more digestible material. Thanks

@cameronp3157 3 жыл бұрын

Great video man! The best explanation of sub queries that I found! This is helping me a lot because I'm starting with a course of T-SQL

@kramoo 4 жыл бұрын

Absolutely amazing explanation and you give hope that you said it took you a while, now look at you.

@dfgndfghdfghdfgh 3 жыл бұрын

super helpful and you explain stuff in a way where you don't rush through it but also don't take ages on it.

@kristiankelloway127 Ай бұрын

The idea that a subquery in a FROM statement creates a table and starting the query process from there was a real lightbulb moment - thank you

@EverythingData98 Жыл бұрын

I am getting ready for an internship using SQL as a data analyst and this made a ton of sense, thanks! I will be subscribing

@aadhyatiwari9688 6 ай бұрын

did you get the internship? just curious lol

@samuelopoku-acheampong5601 3 жыл бұрын

Thanks for the tutorials, you have being of great help on this journey...Keep them coming

@topemorada 3 жыл бұрын

Your SQL knowledge is admirable.

@kw9303 Жыл бұрын

Just started a Business Systems Analyst entry level position that uses SQL everyday and this video has been so helpful! You explained it better than the corporate instructor, Khan Academy and my Udemy course! THANK YOU!!!!

@jcopas1826 2 жыл бұрын

This was very helpful. It saved me a lot of time. I understood it the first viewing and was able to apply the concepts with ease and complete my homework on time. Thank you, you do an excellent job. I will come back for future questions in SQL.

@jude3026 3 жыл бұрын

you just helped me through my project in SQL, thankss a lot!

@AlexMar-r 7 ай бұрын

So easy to understand without broken English. Keep them coming!

@manaygun Жыл бұрын

Simple and direct. Just what I was needed.

@user-go2pt8ef4q Жыл бұрын

Thank you for explaining it the way you did, it just clicked for me. Great stuff! Keep up the good videos.

@1mmoralls 2 жыл бұрын

Great video! Thank you so much for bringing a clear explanation of this topic. I look forward to viewing your other videos.

@andyn6053 3 жыл бұрын

great videos! Its soo much easier too understand when watching your tutorials! Please do more advanced videos with window functions etc.

@ripndipp 4 жыл бұрын

Excellent explanation, these sub queries got me messed up but this video helped. Your great and explaining and hoping you succeed with your channel, you seem like a genuine dude.

@becomingADS 4 жыл бұрын

Thanks a lot for the kind words, means a lot!

@sopauljauck4163 3 жыл бұрын

Thank you for summing up subquery. Thank you.

@davidcoley4156 2 жыл бұрын

A great, and much needed take on this subject.

@basetroll1627 3 жыл бұрын

Very helpful, some key explanation that made it "click" with me. And most of all, I like that you confess to your struggle at the beginning, beacause I have my though times right now....

@anievgenieva8267 3 жыл бұрын

Thank you! You look so positive and warm person :)

@EK-ee4gb 3 жыл бұрын

Awesome explanation. Thank you very much. I was completely lost on subqueries.

@woodynani4394 4 жыл бұрын

Thank you for your effort, keep moving

@petrblue Жыл бұрын

Thanks, great explanation!

@jaimetirado6130 2 жыл бұрын

Very helpful - thank you !!

@lazarus8011 2 жыл бұрын

Thanks helped me out heaps!

@SjeetjeMineetje 3 жыл бұрын

All your videos are very helpful and well explained! Helps me a lot in understanding SQL better. Are you planning on doing any more on SQL soon?

@jorgeduardo101 2 жыл бұрын

Awesome vid! thanks bud :)

@ALEX86ZILBER 10 ай бұрын

Thank you, a great explanation and examples for subqueries.

@mitul509 3 жыл бұрын

I like how you explain, keep up the good work.

@jeevak840 6 ай бұрын

Actually for me this makes amazing sense. Thanks for the tutorial.

@tyroneogarrojr.453 Жыл бұрын

Great video, very comprehensive!

@jhonpeteranduyon7247 3 жыл бұрын

Thank you! This helps me a lot.

@borjonx 3 жыл бұрын

This is exactly what I was looking for - thank you for sharing!

@borjonx 3 жыл бұрын

Does the internal table have to be the same as the outer table? "orders" in your example.

@srem1971 3 жыл бұрын

Great explanation. Thank you!

@josemunguia5660 4 жыл бұрын

Great content! Thanks!

@shehanguruge7025 3 жыл бұрын

Well explained thanks a lot finally was able to get a better grasp of Sub Queries

@mattk3650 4 жыл бұрын

thanks man, appreciate the explanation

@alexg97343 Жыл бұрын

Great video easy to understand

@locke827 5 ай бұрын

Great explanation. Thank you :)

@ced4298 2 жыл бұрын

Really good explanation. I will be glad to share this with developers who write "expensive" queries with complex join statements.😀

@PythonArms 2 жыл бұрын

explained very well. thank you

@alejguz1552 Жыл бұрын

Thank you for sharing, I feel stupid not understanding, but you kind of make it clearer

@justineasterday4695 4 жыл бұрын

Dude this was great.

@rackellewilkinson-alston 3 жыл бұрын

loved this!!!

@williammandang 3 жыл бұрын

I didn't understand the concept one bit and I didn't understand why we should use them when I was in the university, but I understand now lol. Thanks for the tutorial. It's simple, yet really helpful for me

@kenchin5722 3 жыл бұрын

That was great Explaination.

@lamborghiniveneno8423 2 жыл бұрын

And The search ends here.... Perfect 💯

@dkfwlqvkdlf35 3 жыл бұрын

AWESOME! thank you for your effort!

@liwaygorzon 4 ай бұрын

hope you would keep on making SQL tutorials (or other programming language). you help me a lot in my review for my assessment. you have explained each topic very well! I'm learning a lot from you.

@jessibaby901 2 жыл бұрын

overwhelmed?! tuh... i am terrified! i came to you, from my online course, for some type of clarity. what did I get you might ask. HUMBLED! tfs this video anyway, I'm hopeful I will find some gems on your channel. -your new (maybe in over her head) subscriber

@kbishop9360 2 жыл бұрын

Thanks for this sql series

@nathanbenton2051 4 жыл бұрын

Great videos - keep it up!

@Beavin_it_up 2 жыл бұрын

thank god for this video!

@VaaniMogan Ай бұрын

Thank you for this brilliant video. Please upload more :) :).

@orangefish9825 3 жыл бұрын

This helped, thank you!

@alvrey3390 3 жыл бұрын

Amazing Explanation Thank you 🙌

@omarkhaled6006 Жыл бұрын

amazing man good job

@paulntalo1425 3 жыл бұрын

Thank you for the video

@williamredwine722 Жыл бұрын

Thank you for this video

@hungrygarfield Жыл бұрын

You’re a real G

@maniijuan Жыл бұрын

You sir are such a great teacher. Thank you

@nijulllee Жыл бұрын

Thank you bro man 💥

@ahmedopeyemi2980 10 ай бұрын

Where the heck have you been? You’re the only useful person on KZfaq!

@bhargav7476 3 жыл бұрын

I bought a course on Udemy, you solve like 10 doubts I had in just 1 video

@factorise001 2 жыл бұрын

keep it up!!

@TheOrionMusicNetwork 3 жыл бұрын

Brilliant explanation The online course I took had me lost at this part.

@jettecantoria Жыл бұрын

Thank you again

@Virtualexist 3 жыл бұрын

Hi there, I really liked the explanation, just a suggestion if you would give a very quick overview of the heads of the dataset so that it is easier to comprehend more how the query/subquery is extracting the data.

@marianneescande2685 4 жыл бұрын

Very helpful! Thank you 😊

@becomingADS 4 жыл бұрын

Glad it was helpful!

@GeloEd 2 жыл бұрын

There are also subqueries in join. It's hard to find a material as good as this. Leaving a like and comment to support your channel.

@Robert8455 2 жыл бұрын

Thanks!

@astonmargolis4391 Жыл бұрын

thank you!

@DataNovelties 3 жыл бұрын

Lovely. Thanls a lot for this great share 👌🙂

@dawitworku821 2 ай бұрын

Very helpful. Than you.

@gotchihaeyo1825 Жыл бұрын

Thank you.

@MrSoccerHighlighter 4 жыл бұрын

Awesome!

@zoeteets9353 2 жыл бұрын

This is so helpful! Thank you!! Rec: time stamps for each example

@alirezaghanbarzadeh1679 3 жыл бұрын

nice job!

@Joaquino991 3 жыл бұрын

Thank you!

@qpe04 2 жыл бұрын

Hi How's going ? Thank you for the video! I have a question about "inner query gets executed first", does it only apply to the subquery in FROM statement or no matter in SELECT/ FROM / Where statement ? Thank you very much!

@trucco16 3 жыл бұрын

you are a champion thanks a lot..(im buying your book also!!!)

@ankitachouhan6640 3 жыл бұрын

Great explanation! Do you have a video for Correlated Subquery as well? It is super confusing

@felipestuardo123 3 жыл бұрын

Hi! What program are you using to code? thank you! and what DBMS are u using

@jennifergonzalez6431 3 жыл бұрын

What does the 1,2 mean in the Group By 1,2?

@alialazawi2849 Жыл бұрын

love u bro

@amoghnigam7276 2 жыл бұрын

THANK YOU

@Mika-hk3sm 9 ай бұрын

does the "group by 1,2" also work in oracle db?

@Agadr 2 ай бұрын

thank youuu

@ninaa9294 3 жыл бұрын

Great Thank you. How can i use joins with it?

@noobedition9109 3 жыл бұрын

very helpful video. I just have a question, which one is better(most "performant") , doing a subquery or a join?

@cvendet1 3 жыл бұрын

When doing a sub query (inner SELECT) and referencing it from the outer SELECT statement can I use a WHERE clause in the outer SELECT Statement or does it need to be in the Inner SELECT Statement? Similarly once I have established my inner SeELECT statement can I then use those columns in a CASE Statement?