programming-examples/15. Write a query to extract the data from the customer table if and only if one or more of the customers in the customer table are located in London.sql at master - programming-examples - michuIT: Everything is code

You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

8 lines

293 B

SQL

Raw Permalink Blame History

 /*15. Write a query to extract the data from the customer table if and only if one or more of the customers in the customer
 table are located in London.*/
 SELECT customer_id,cust_name, city
 FROM customer
 WHERE EXISTS
    (SELECT *
     FROM customer
     WHERE city='London');