Shulou(Shulou.com)06/03 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.