In Chapter 2, Select Statements, we worked with various forms of projection, in which
SELECT statements allowed us to choose the columns we want to display. In this chapter, we explore the concept of selection, which allows us to limit our datasets to display only data that meets a certain set of conditions. Much of the chapter is spent examining the different types of conditions we can set. We will also learn the ways in which SQL can sort our data using the
BY clause. By the end of this chapter, we will use both projection and selection to retrieve very specific sets of data and sort them in the order we wish.
In this chapter, we will cover the following topics: