EXISTS 在SQL语句中怎么用？

EXISTS
指定一个子查询，检测行的存在。

SELECT DISTINCT name
FROM student
WHERE EXISTS
(SELECT *
FROM register
WHERE id = student.id);

(note that if some rows in student register.id =student.id, all those rows in student are selected out.)

 

更多请看下节：https://blog.csdn.net/qq_44591615/article/details/109204925