Oracle Learning Notes Comparison operations

< >= <= >= <> (not equals)! = (Not equal to): = (Assignment)

Between......and (contains boundaries in an interval)

--Query wages from 2000 to 5000 of the salary select salary from employees where salary between2000and5000

In ()

--Query 80,90,70,50, department number person select last_name from Employees where department_id in (80,90,70,50)

Like

--The name contains the letter "A" of the select last_name from employees where last_name like '%a% '--the second letter in the name is "a" select last_name from Employees whe Re last_name like ' _a% '--the second letter in the name is "_", escape for the translation character select last_name from employees where last_name like ' #_% ' escape ' # '

Oracle Learning Notes Comparison operations