SQL-Coding-Practices-Solutions/AND_OR_NOT condiitions.sql at main · wahidpanda/SQL-Coding-Practices-Solutions · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
--AND operator for all condition are True

select * from Monthly_Salary_SHeet where employee_gender = 'Male' AND employee_age < 27;

-- OR operator for any conditon need True
select * from Monthly_Salary_SHeet where employee_gender = 'Male' OR employee_age > 27;

--NOT condition no one is True
select * from Monthly_Salary_SHeet where not employee_gender = 'Male'