O'Reilly logo

SQL Fundamentals, Third Edition by John J. Patrick

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. Compound Conditions in the Where Clause

In chapter 2, we used fairly simple conditions in the where clause. In this chapter, we discuss how to combine several of these simple conditions into a compound condition. This is particularly important when we are handling tables with many rows. It allows us to specify the particular set of rows we want.

This chapter also discusses several other important topics. You should read this chapter quickly and make sure you do not get bogged down in any part of it. The topics themselves are not really part of SQL. Rather, these are general programming topics that could trip you up along the way if you are not aware of them.

If your main goal is to learn SQL, I recommend that you read the chapter once ...

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