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

For the subquery after exists, exists only cares about whether there is one, and returns a Boolean type.

# case: query the name of the department with employees

SELECT department_nameFROM departments dWHERE EXISTS (SELECT * FROM employees e WHERE d.`department _ id` = e.`department _ id`)

Or

SELECT department_nameFROM departmentsWHERE department_id IN (SELECT department_id FROM employees)

# query the information of male gods who do not have girlfriends

SELECT bo.*FROM boys boWHERE NOT EXISTS (SELECT b.boyfriend_id FROM beauty b WHERE b.`boyfriend _ id` = bo.`id`)

Or

SELECT bo.*FROM boys boWHERE bo.`id`NOT IN (SELECT boyfriend_id FROM beauty b)

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.