Use Scalar Aggregate Functions to Guarantee a Single Value

Subqueries that are introduced with unmodified comparison operators often include scalar aggregate functions, which return a single value.

For example, to find the names of books that are priced higher than the current minimum price:

select title 
from titles 
where price > 
   (select min(price) 
    from titles)
title 
---------------------------------------------------
The Busy Executive’s Database Guide 
Cooking with Computers: Surreptitious Balance
     Sheets
Straight Talk About Computers 
Silicon Valley Gastronomic Treats 
But Is It User Friendly? 
Secrets of Silicon Valley 
Computer Phobic and Non-Phobic Individuals:
     Behavior Variations 
Is Anger the Enemy? 
Life Without Fear 
Prolonged Data Deprivation: Four Case Studies 
Emotional Security: A New Algorithm 
Onions, Leeks, and Garlic: Cooking Secrets of the
     Mediterranean 
Fifty Years in Buckingham Palace Kitchens 
Sushi, Anyone?