Skip to Main Content
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition
book

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition

by John L. Viescas, Michael J. Hernandez
September 2007
Intermediate to advanced content levelIntermediate to advanced
672 pages
13h 23m
English
Addison-Wesley Professional
Content preview from SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition

When You Filter Makes a Difference

You now know two ways to filter your final result set: WHERE and HAVING. You also know that there are certain limitations on the predicates you can use within a search condition in a HAVING clause. In some cases, however, you have the choice of placing a predicate in either clause. Let’s take a look at the reasons for putting your filter in the WHERE clause instead of the HAVING clause.

Should You Filter in WHERE or in HAVING?

You learned in Chapter 6 about five major types of predicates you can build to filter the rows returned by the FROM clause of your request. These are comparison (=, <>, <, >, >=, <=), range (BETWEEN), set membership (IN), pattern match (LIKE), and Null (IS NULL). In Chapter 11, we expanded ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition

SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition

John Viescas, Michael J. Hernandez
Effective SQL: 61 Specific Ways to Write Better SQL, First Edition

Effective SQL: 61 Specific Ways to Write Better SQL, First Edition

John L. Viescas, Douglas J. Steele, Ben G. Clothier
SQL for Data Analytics

SQL for Data Analytics

Upom Malik, Matt Goldwasser, Benjamin Johnston

Publisher Resources

ISBN: 9780321444431Purchase book