Exists « Select Clause « SQL / MySQL

1.Subquery: Using EXIST Operator
2.Use the NOT EXISTS operator in the same way as the EXISTS operator, only the opposite results are returned.
3.Sub query with EXISTS command
4.Sub query with NOT EXISTS command
5.Subquery with EXISTS
6.Exists and subquery
7.Not exists and subquery of constant value