SQL Tutorial : DRL / DQL - Arithmetic Operators

Let's learn about next topic : ARITHMETIC OPERATORS

ARITHMETIC OPERATORS

**************************

{*/} PRIORITY

 + -

SELECT EMPLOYEE_ID,LAST_NAME,SALARY,SALARY*12

FROM EMPLOYEES

SELECT EMPLOYEE_ID,LAST_NAME,SALARY,(500+SALARY)*12

FROM EMPLOYEES

Point to Note:

- WHEN WE HAVE EXPRESSION OF SAME PRIORITY

- EVALUATION IS FROM LEFT TO RIGHT