How to implement subquery by mysql

This article mainly introduces how mysql realizes sub-query, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

A subquery can be understood as a query nested in other statements, so we have different ways to use different query results.

1, sub-query is a single-valued result, then you can use =,> and other comparison operators.

#select * from t_product where price = (select max(price) from t_product)

2. If the subquery is a multi-valued result, you can use [not] in(subquery result) or>all(subquery result).

#Query the highest price of commodity information SELECT * FROM t_product WHERE price >=ALL(SELECT price FROM t_product) Thank you for reading this article carefully, I hope Xiaobian shared "mysql how to achieve sub-query" This article is helpful to everyone, but also hope that everyone more support, pay attention to the industry information channel, more relevant knowledge waiting for you to learn!