The current specification of the SQL standard fails to support users adequately in formulating complex queries involving set comparison that tend to arise in on-line analytical processing (OLAP) situations. Such queries must be formulated using correlated subqueries and the NOT EXISTS function which present an overwhelming challenge to both casual as well as everyday SQL users. This paper presents a simpler approach for teaching users how to formulate in SQL complex set comparison queries encountered in ad-hoc decision making scenarios.
"A Simpler Approach to Set Comparison Queries in SQL,"
Journal of Information Systems Education: Vol. 14
, Article 1.
Available at: https://aisel.aisnet.org/jise/vol14/iss4/1