Chapter 10
Zeroing In on the Data You Want
IN THIS CHAPTER
Specifying the tables that you want to work with
Separating rows of interest from the rest
Building effective WHERE clauses
Handling null values
Building compound expressions with logical connectives
Grouping query output by column
Putting query output in order
Operating on related rows
A database management system has two main functions: storing data and providing easy access to that data. Storing data is nothing special; a file cabinet can perform that chore. The hard part of data management is providing easy access. For data to be useful, you must be able to separate the (usually) small amount you want from the huge amount ...
Get SQL For Dummies, 9th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
