SQL Operators
Operator The purpose operators is to perform the manipulations with attributes. These Operators are following 1. Relational Operators - for comparing purpose 2. Arithmetic Operators - for mathematical operations 3. Logical Operators - for compare with multiple conditions or opposition conditions 3. Special Operator - for special purpose comparison Relational Operators >, <, >=, <=, =, !=, <> Examples: Display the details about employee whose name is SMITH select *from emp where ename='SMITH'; Display the details about employees whose salary is greater than 3000 select *from emp where sal > 3000; Display the details about employees except MANAGER select *from emp where job <>'MANAGER' ; or select *from emp where job !='MANAGER' ; Arithmetic Operators +, -, *, / Logical Operators and, or , not Example Display the details about MANAGERS whose salary is greater than 2500 select ename, job, sal from emp where job='MANAGER' and sal...