If you have a table that looks something like following: TABLE Boxes A B C 2 2 1 4 9 2 5 2 6 6 1 1 Then, you could do something like this: SELECT A/2 as Calc1, B*2 as Calc2, C - (C*25) as Calc3 FROM Boxes; And if you don't want any titles, then remove "as CalcXXX" part!