Chapter 10

Zeroing In on the Data You Want

In This Chapter

arrow Specifying the tables you want to work with

arrow Separating rows of interest from the rest

arrow Building effective WHERE clauses

arrow Handling null values

arrow Building compound expressions with logical connectives

arrow Grouping query output by column

arrow Putting query output in order

arrow 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 you ...

Get SQL For Dummies, 8th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.