previous | start | next

Self Check

  1. Suppose you want to test whether there are any customers in Hawaii. Issue the statement 
    ResultSet result = stat.executeQuery(
      "SELECT * FROM Customer WHERE State = 'HI'");
    Which Boolean expression answers your question?
  2. Suppose you want to know how many customers are in Hawaii. What is an efficient way to get this answer?
previous | start | next