Lesson 10 - MySQL Step By Step: Subqueries
In the previous lesson, MySQL Step By Step: Exercises to practise, we practiced queries on several examples. Today's lesson is all about subqueries, so it's going to complete our knowledge of the SQL basics.
Subqueries
A subquery is a query that's part of another query. Right, we can nest queries into another. Like this, we can use the output of one query as an input for another query because it's basically also a data table. In practice, this is widely used, and we have the ability to get all the results straight from the database that we'd otherwise have to put together in our application.
Of course, subqueries are performance-intensive, but if they're optimized
properly (see the next lessons) they should be faster than using multiple
separate queries or JOINs.
Try to think about how'd you list articles of the user whose nickname is "David". You might think of the following query:
...End of the preview...
Continue further
You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.
Buy this course
Before buying this article, you have to buy the previous one
This article is licensed: Premium, by buying this article, you agree with the terms of use.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
Article description
Requested article covers this content:
In this tutorial, we'll learn to use subqueries, nested queries in MySQL database. We'll explain new operators: IN, ALL, ANY, and EXISTS.
You gain credits by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.
David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.