Chapter 10

Zeroing In on the Data You Want


Bullet Specifying the tables that you want to work with

Bullet Separating rows of interest from the rest

Bullet Building effective WHERE clauses

Bullet Handling null values

Bullet Building compound expressions with logical connectives

Bullet Grouping query output by column

Bullet Putting query output in order

Bullet 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 live online training, plus books, videos, and digital content from nearly 200 publishers.