4. Filtering and Finding Data

Perhaps the most important task you can do in SQL when attempting to turn the data found in one or more tables into useful information is look for data of interest or filter out data not of interest. Sometimes filtering involves matching an entire set of data with another entire set. Other times you accomplish filtering by testing for specific values in one or more columns. This chapter explores all the techniques you can use to find exactly the information you need from your database.

Item 22: Understand Relational Algebra and How It Is Implemented in SQL

Dr. Edgar F. Codd is widely recognized as the “father” of the relational model of database management. He introduced terms such as relation (a table or view), ...

Get Effective SQL: 61 Specific Ways to Write Better SQL, First Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.