We Learn SQL #9 | Simple subqueries in SQL

Показать описание

A subquery is a SQL query nested inside a larger query. They are extremely useful, thanks to which your code will be easier to read, simpler, so you will work much faster and more efficiently.

Hello, my name is Adrian, and this is a series of videos devoted to the basics of SQL. This time, we’re going to give you an introduction to SQL subqueries, a very powerful tool when creating SQL queries.

Let’s learn SQL together!

👌 Subscribe to our channel and leave a comment!

👌 Do you want to learn SQL? Go to LearnSQL.com and choose the course or track that is best for you!

Рекомендации по теме

Комментарии

Awesome explanation, I coudn't understand subqueries in a website that i joined. So, I came to youtube, thinking that I can clear my doubt here. I was three videos in and I still didn't understand. Finally as my last hope, I thought to click on this video and now I understand what subqueries exactly do. Thank you!

siddhantfursule

Great explanation - I just did a paid course looking at this topic and your explanation was much better. It makes much more sense to say that you can evaluate the query to return a single value, and then input that subquery (which returns the result) into another - just like composition of functions in programming (or math). I am going to watch all your videos now.

smashingtennis

This was wonderfully explained, thank you!

DavidaThatch

Awesome awesome awesome explanation! This was the video that made sub queries start to make sense to me. Thank you!

TheDiscretion

Wow. Great explanation! Thank you for explaining complex subjects in a reductive way that makes it easier to understand!

DonAusby

Thank you for the really good explanation!!!

basiabbas

Content is great, but the music is quite loud.

Trazynn

Thanks Nicely explained !!! Is it same way in mysql?

suyashsrivastava

What’s the impact pf subqueries in terms of speed in getting high number of rows?

clarosantiago

Kindly help me understand what data types did you use

naomirono

Is "where rating > AVG(rating)" wrong?

pavlerakic

omg...why the heck do you have to add background music? We need to listen to your content and not the music. Such a distraction. drives me crazy.

RishiRap

We Learn SQL #9 | Simple subqueries in SQL

Learn and Practice SQL | Learning SQL has never been easier!

Learn SQL: Query 9: Functions COUNT() GROUP BY

SQL Tutorial 9: SQL Joins and Sub Queries

We Learn SQL #13 | Intro to correlated subqueries in SQL

SQL session 9 | A few more Datatypes | Trendytech

We Learn SQL #15 | SQL Subqueries in SELECT

6 SQL Joins you MUST know! (Animated + Practice)

We Learn SQL #4 | SQL LEFT RIGHT and FULL JOIN

SQL Server TSQL Training from SQL School Part-1

We Learn SQL #14 | Correlated subqueries with EXISTS in SQL

MySQL - The Basics // Learn SQL in 23 Easy Steps

SQL Tutorial for Beginners

SQL Tutorial - Full Database Course for Beginners

SQL Tutorial - 9: Create Table Statement

Top 10 SQL Interview Queries | Popular SQL Queries for SQL Interview

Why Learn SQL?

IGCSE Computer Science 2023-25 ​​- Topic 9 DATABASES: Video 3 - SQL Structured Query Language

How long does it take to MASTER SQL?

What is SQL? [in 4 minutes for beginners]

I learned SQL for data analytics in 15 days | From Scratch

SQL Tutorial for Beginners [Full Course]

SQL - Complete Course in 9 Hours | SQL One Shot | SQL Full Course by Sumit Sir

Oracle SQL Tutorial 9 - Intro to Queries

SQL | How to Upload / Restore a Database in SQL Server?

IGCSE Computer Science 2023-25 - Topic 9 DATABASES: Video 3 - SQL Structured Query Language