Consider the following table /relation. What is the output for the below Query?
CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('101','A','Ram','1-2 Ramnagar','mumbai');
INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('102','B','Ravi','1-2 samnagar','mumbai');
INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('103','C','Raju','1-2 Narayanapuram','Mahabubabad');
INSERT INTO Persons (PersonID, LastName, FirstName, Address, City)
VALUES ('104','D','Ramraju','1-3 Narayanapuram','Hyderabad');
Query:
Select *
from Persons
Where City in('Mumbai', 'Hyderabad');