[Solved] Order of execution for divide,multiply,subtract in sql query [closed]

by


Same as any other… Based on PEMDAS

Parenthesis

Exponents

Multiply 
  and 
Divide at same level, left to right

Add 
  and 
Subtract at same level left to right.




(D-E) is done first
(B) is done next, but is left as-is as no other direct relation 
A * B
C * 100
then 
(result of C * 100) / (D - E result)
(A * B result ) - ( entire C * 100 / (D-E) result)

1

solved Order of execution for divide,multiply,subtract in sql query [closed]