24.4.2 WHERE Clause
In most cases, it’s necessary to locate rows in a database that satisfy certain selection criteria. Only rows that satisfy the selection criteria (formally called predicates) are selected. SQL uses the optional WHERE clause in a query to specify the selection criteria for the query. The basic form of a query with selection criteria is
SELECT columnName1, columnName2, ... FROM tableName WHERE criteria
For example, to select the Title
, EditionNumber
and Copyright
columns from table Titles
for which the Copyright
date is greater than 2013
, use the query
SELECT Title, EditionNumber, Copyright FROM Titles WHERE Copyright > '2013'
Strings in SQL are delimited by ...
Get Java™ How To Program (Early Objects), Tenth 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.