A Simpler Approach to Set Comparison Queries in SQL

Authors

Mohammad Dadashzadeh, Oakland University

Abstract

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.

Recommended Citation

Dadashzadeh, Mohammad (2003) "A Simpler Approach to Set Comparison Queries in SQL," Journal of Information Systems Education: Vol. 14 : Iss. 4 , 345-348.
Available at: https://aisel.aisnet.org/jise/vol14/iss4/1