DML-select-Where:

nIt is used to retrieve one or more records

nAny relational operator can be coded(<,>,<=,>=,=,<>,)

Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

Query:

Select * from emptbl1 where empsal=10,000