SQL 2

SQL AND & OR Operators :

student table :

student name	Contact	Address	City	Country
Ayush	89045	Old Ib road	Bagalkot	India
Akshay	7899	GM road	Belgaum	India
Pavitra	8649	Hosur	Belgaum	India
Pooja	9978	Busstand road	Gadag	India

 

 

AND operator :

SELECT * FROM student
WHERE Country='India'
AND City='Bagalkot'; 

OR operator :

 
SELECT * FROM student
WHERE City='Hubli'
OR City='Belgaum';

 

Combination of AND and OR operator :

 

SELECT * FROM student
WHERE Country='India'
AND (City='Bagalkot' OR City='Hubli');