Tag Archives: sql null

IS NULL OPERATOR Let’s list the employees that have manager. SELECT first_name,last_name, manager_id FROM hr.employees WHERE manager_id IS not NULL;   LOGICAL OPERATORS AND : It returns TRUE if all …

ARITHMETIC OPERATORS Arithmetic operations can be used on the data which type is ‘date’ or ‘number’. The priority of the operators is like below ;   USAGE OF THE ARITMETHIC …