MySQL AND, OR, NOT Operators Tutorial in Pashto

use db ; SELECT * FROM emp where department = 'HR' ; SELECT * FROM emp where department = 'database' ; SELECT * FROM emp where salary = 50000 ; SELECT * FROM emp where salary = 20000 ; SELECT * FROM emp where department = 'HR' ; SELECT * FROM emp where department <> 'HR' ; SELECT * FROM emp where salary > 20000 ; SELECT * FROM emp where salary < 20000 ; SELECT * FROM emp where salary <= 20000 ; SELECT * FROM emp where salary >= 20000 ; use db; SELECT * FROM emp ; SELECT * FROM emp where department = 'HR'; SELECT * FROM emp where department between 'HR' and 'IT'; SELECT * FROM emp where age between 26 and 28; SELECT * FROM emp where age between 28 and 40; SELECT * FROM emp where age in (26, 28,34); SELECT * FROM emp where ag = 34; SELECT * FROM emp where department in ('HR', 'IT', 'Database'); SELECT * FROM emp where department not in ('HR', 'IT', 'Database'); SELECT * FROM emp where department is null; SELECT * FROM emp where department is not null; SELECT * FROM emp where first_name like 'H%' ; SELECT * FROM emp where first_name like 'Hik%' ; SELECT * FROM emp where first_name like '%ik%'; SELECT * FROM emp where last_name like 'Ah%ad%'; SELECT * FROM emp where salary like '50%'; SELECT * FROM emp where last_name like 'S%'; SELECT * FROM emp where last_name not like 'S%'; SELECT * FROM emp where salary not like '50%';