SELECT Overview and Syntax
In many ways, the SELECT statement is the real heart of SQL. It lets you find and view your data in a variety of ways. You use it to answer questions based on your data: how many, where, what kind of, even what if. Once you become comfortable with its sometimes dauntingly complex syntax, you'll be amazed at what the SELECT statement can do.
Because SELECT is so important, five chapters focus on it:
This chapter begins with the bare bones: the SELECT, FROM, and WHERE clauses, search conditions, and expressions.
Chapter 5 delves into some SELECT refinements: ORDER BY, the DISTINCT keyword, and aggregates.
Chapter 6 covers the GROUP BY clause, the HAVING clause, and making reports from grouped data. Chapter 6 also summarizes ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.
