O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Using Conditional Statements

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 ORDER 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:

  • Examining the concept of data selection ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required