If apple, orange, mangoes and grapes are the column names then you can use the following query: select apple*2 as getapple, orange*4 as getorange, mangoes*3 as getmangoes, grapes/10 as getgrapes, banada*2 as getbananas, watermelon*10 as getwatermelon from TABLENAME