SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 16

Figure 2-5: SQL Operators grouped together into four groups.
SELECT *
FROM ssa;
One other aspect is, why to look for something you don't need. If
you are looking one person's information why to execute the
query that will give you all the records rather executing the
following query.
SELECT *
FROM ssa
WHERE ssn = '123-455-6677';
The way we have used the “greater than” operator on the same
lines we can use the “less than” (<), “equal to” (=), “less than
equal to” (<=) & “greater than equal to” (>=). ANY/SOME and