The SQL AND & OR operators used
to filter the record that is based on one or more condition.
The AND operator used to show the
record if both first and second condition are true.
The OR operator used to show the
record if either the first condition OR second condition is true.
Example – Firstly we create the
table “emp”
AND operator Example –
select * from emp where id='1' AND name='sachin'
Output –
OR operator Example –
select * from emp where id='1' OR name='pramod'
Output –
