SQL AND & OR Operators

The AND & OR operators are used to filter records based on more than one condition.

The AND & OR Operators

The AND operator displays a record if both the first condition and the second condition is true.

The OR operator displays a record if either the first condition or the second condition is true.

AND Operator Example

The "student" table:

Student _No	Student_Name	Address	Year_Study	Sex	Date_of_birth	Course_No
ST100	K.Ranjan	Kandy	1	Male	17/01/1988	C1
ST101	N.Kumanan	Jaffna	2	Male	15/12/1989	C2
ST102	S.Ranjini	Vavuniya	1	Female	17/01/1989	C1
ST103	K.Dias	Colombo	3	Male	22/07/1987	C1
ST104	A.Kavitha	Matara	3	Female	20/03/1985	C2
ST105	L.Lavanya	Galle	2	Female	22/04/1989	C2
ST106	G.Moorthy	Jaffna	2	Male	12/01/1986	C1
ST107	F.Nathan	Matara	2	Male	29/01/1990	C3
ST108	A.H.M.Akmal	Puttalam	1	Male	12/12/1990	C3

Now we want to select only the student with the Student_Name equal to " K.Ranjan " AND the Year_Study equal to 1 :


We use the following SELECT statement:

SELECT * FROM student
WHERE Student_Name = 'K.Ranjan'
AND Year_Study = 1;


The result-set will look like this:

Student_No	Student_Name	Address	Year_Study	Sex	Date_of_birth	Course_No
ST100	K.Ranjan	Kandy	1	Male	1988-01-17	C1