How to use multiple where condition in SQL?

Question

Can anyone tell me how to use multiple where conditions in SQL?

Answer 1

You can use AND, OR, and IN operators to use multiple conditions in where clause. Here are three examples of how you can use multiple conditions in where clause:

If you want to find the employee details whose salary is greater than 40000 and age less than 25.

SELECT EMP_ID, Employee_Name, Salary

FROM CUSTOMERS

WHERE Salary > 40000 and AGE < 25;

If you want to find the employee details whose salary is greater than 40000 or age less than 25.

SELECT EMP_ID, Employee_Name, Salary

FROM CUSTOMERS

WHERE Salary > 40000 or AGE < 25;

If you want to find the employee details whose location is Bangalore or Hyderabad.

SELECT EMP_ID, Employee_Name, Salary

FROM CUSTOMERS

WHERE Location in (‘Bangalore’, ‘Hyderabad’);

I recommend enrolling in this SQL course by Intellipaat to learn SQL.