Big Java, Binder Ready Version: Early Objects
Big Java, Binder Ready Version: Early Objects
6th Edition
ISBN: 9781119056447
Author: Cay S. Horstmann
Publisher: WILEY
Expert Solution & Answer
Book Icon
Chapter 24.2, Problem 3SC

Explanation of Solution

Query to find the names of all customers:

The below query is used to select the names of all customers except from Alaska and Hawaii in the “Customer” table.

SELECT Name FROM Customer WHERE State <> 'AK' AND State <> 'HI';

Explanation:

In the above query,

  • “SELECT” – It is used to extract values of the “Name” field from the “Customer” table...

Blurred answer