Home / code / sql

Calculations in SQL

You can do a number of calculations with SQL:
SELECT prize/40.3399 AS convertedineuro FROM table
This converts the prize from Belgian Franks to Euros.

These are the calculation you can do:
add(+), minus(-), multiply(*), divide(/) and x�=x*x*x(^)

 

TOP