How to calculate expressions with sql statements?



How to calculate expressions with sql statements?..

Answer / Suresh Kumar Gautam

To perform calculations (e.g., addition, subtraction, multiplication, division) in SQL statements, use the respective arithmetic operators:nnFor example: nn* `SELECT column1 + column2 AS sum_result FROM your_table;` for adding two columns and giving the result a new name

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is the full meaning of mysql?

1 Answers  


How to print message in mysql trigger?

1 Answers  


How to increment dates by 1 in mysql?

1 Answers  


What does "i_am_a_dummy flag" do in mysql?

1 Answers  


What is the datatype of image?

1 Answers  


How to enter boolean values in sql statements?

1 Answers  


Why do we use views instead of tables?

1 Answers  


What is the difference between myisam dynamic and myisam static in mysql?

1 Answers  


What is myisam?

1 Answers  


Is mysql is a programming language?

1 Answers  


How do you determine the location of mysql data directory?

1 Answers  


What is mysql common?

1 Answers  


Categories