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 |
What is the full meaning of mysql?
How to print message in mysql trigger?
How to increment dates by 1 in mysql?
What does "i_am_a_dummy flag" do in mysql?
What is the datatype of image?
How to enter boolean values in sql statements?
Why do we use views instead of tables?
What is the difference between myisam dynamic and myisam static in mysql?
What is myisam?
Is mysql is a programming language?
How do you determine the location of mysql data directory?
What is mysql common?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)