Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
of all customers who have never ordered”. The SQL statement written by using the correlated subquery is as follows. It can be seen that the “not exists” subquery uses the external column c_custkey. -- Information of all customers who have never ordered Select c_custkey from customer where not