We Learn SQL #15 | SQL Subqueries in SELECT

Опубликовано: 01 Январь 1970
на канале: We Learn SQL

11,651

225

We’re going to learn about SQL subqueries in the SELECT clause. Find out how to use them correctly and how it will improve your work with databases.

If you want to learn or practice SQL, check out https://learnsql.com/.

It is very important to remember that a subquery in the SELECT clause must return exactly one row with exactly one column. If it returns more than that, you’ll get an error, and the query won’t work. For this reason, this sort of subquery frequently uses an aggregate function such as AVERAGE or SUM because such a function aggregates the rows and returns exactly one value.

Without further ado, let’s get started!

👌 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!

👌 Join us on Facebook: / welearnsql

🔊 Music: https://www.bensound.com/