Chapter 18
Advanced Retrieval Operations
Abstract
This chapter covers advanced retrieval operations such as unions, negative queries, special operators (EXISTS, EXCEPT, AND INTERSECTION), arithmetic in SQL queries, string manipulation, and date and time manipulation.
Keywords
SQL
SQL retrieval
SQL UNION
SQL EXISTS
SQL EXCEPT
SQL INSTERSECT
SQL arithmetic
SQL string manipulation
SQL date manipulation
SQL time manipulation
To this point, the queries you have read about combine and extract data from relations in relatively straightforward ways. However, there are additional operations you can perform on relations that, for example, answer questions such as “show me the data that are not …” or “show me the combination of data that are …”. In this chapter, ...
Get Relational Database Design and Implementation, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
