You can also use CASE WHEN Statements eg. select fruits, N, CASE WHEN fruits='apple' THEN N*2 WHEN fruit='orange' THEN N/2 END as calculatedcolumn from yourtable you can add multiple When statements to include all other cases