SQL And & OR keyword with example

And, OR Keyword

Used to get more filtered record
Table: <

Emp_id	Emp_name	Emp_reg	Emp_salary
01	chandan	E_01	25000
02	adhiraj	E_02	30000
03	raghu	E_03	35000
04	Alax	E_04	40000

you need to find the Emp_name which have Emp_reg = R01 & Emp_id = 1
Select Emp_name from Salary Where Emp_reg = "R01" and Emp_id = 1
RESULT:
chandan Consider above table again & suppose you need to find the Emp_name which have Emp_reg = "R01" or Emp_id = 2 Select Emp_name from Salary Where Emp_reg = "R01" OR Emp_id = 2
RESULT:
chandan
adhiraj

Tag:SQL And, OR query with example, Use of SQL AND OR with example