O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

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

5

Filtering Rows

In this chapter:

  • How do you filter rows out of a query?

  • What are conditional comparisons?

  • What are logical operators?

This chapter extends the syntax of the SELECT statement by examining WHERE clause filtering, conditional comparisons, and logical operators. Filtering is a process of retrieving a subset of the rows retrieved by the SELECT statement.

5.1 WHERE Clause Syntax

We saw two of the primary parts (or clauses) of an SQL query in the previous chapter, namely the SELECT clause and the FROM clause. This chapter adds the WHERE clause. Here is a quick description of each clause:

  • SELECT. List all the columns you want to see in your report here. Separate them with commas. Use an asterisk (*) instead of a list of columns to ...

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