Java™ How To Program (Early Objects), Tenth Edition

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

Click here to view code image

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

Click here to view code image

SELECT Title, EditionNumber, Copyright   FROM Titles   WHERE Copyright > '2013'

Strings in SQL are delimited by ...