निम्नलिखित सारणी /संबंध पर विचार करें।नीचे दी गई क्वेरी के लिए आउटपुट क्या होगा?
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');