What result set is returned from the following SQL query ? Select…
2017
What result set is returned from the following SQL query ? Select customer_name, telephone From customers Where city in ('Jaipur', 'Delhi', 'Agra');
- A.
The customer_name of all customers who are not living in Jaipur, Delhi or Agra.
- B.
The customer_name and telephone of all customers.
- C.
The customer_name and telephone of all customers living in either Jaipur, Delhi or Agra.
- D.
The customer_name and telephone of all customers living in Jaipur, Delhi and Agra.
Attempted by 689 students.
Show answer & explanation
Correct answer: C
The SQL condition selects only those records where the city is any one of Jaipur, Delhi, or Agra. The query returns customer_name and telephone of customers living in either of these cities.
A video solution is available for this question — log in and enroll to watch it.