Where Clause (DRL / DSL)

DRL - data retrieve language

DSL - data selection language

The SQL WHERE clause is used to filter the results and apply conditions in a SELECT, INSERT, UPDATE, or DELETE statement.

===========================================
select * from employee1
where 
description='Tester'

===========================================
select * from employee1
where description='Tester'
or
empid>=6
===========================================
select * from employee1
where 
(description='Tester' and empid<=7)
or
(
first_name='David'
)

===========================================