Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

More Advanced Uses of SELECT

So far today you have seen the fundamental uses of the SELECT query. You'll now see how to use this versatile query in some more sophisticated ways.

Restricting the Resultset with HAVING

On some occasions when you're writing a query, you want to restrict the resultset on the basis of some data in the resultset that has been aggregated.

For example, suppose that you want to find, out of the table of child_products, which age range has products costing less than $10.00.

You want to write this:

SELECT age, MIN(price) FROM child_products
  WHERE MIN(price)<10.00
  GROUP BY age

This query, if it worked, would group the products by age, use MIN() to find the minimum price in each group, and return results where the minimum ...

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

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book