What is a Subquery in MySQL?

[SandraJose]

Hi

I think PostgreSQL supports subqueries while MySQL doesn't. Is it true?

[paullopez]

Hi

MySQL supports subqueries so it is not true. Actually Subqueries are complex and large topic to discuss. Anyway to define What is a Subquery? we will look at a simple example.

a SELECT statement that is most frequently used as part of another SELECT statement, but could also be utilised with an INSERT, UPDATE, or DELETE and other statements. Subqueries are utilised in order to attain very difficult searches and hard reports, as well as for different optimizations.