w3resource
Run SQL Query

SQL: Display the result of an arithmetic expression

SQL Basic Select Statement: Exercise-5 with Solution.

Write an SQL query to display the result of an arithmetic expression.

Sample Solution:

SELECT 10 + 15 - 5 * 2;

Output of the Query:

?column?
15

Explanation :

Syntax of display the result of an arithmetic simplification

Pictorial presentation :

Result of an arithmetic simplification

Practice Online


Query Visualization:

Duration:

Query visualization of Display the result of an arithmetic simplification - Duration

Rows:

Query visualization of Display the result of an arithmetic simplification - Rows

Cost:

Query visualization of Display the result of an arithmetic simplification - Cost

 

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query to display the sum of two numbers 10 and 15 from RDMS sever.
Next: Write a SQL statement to display specific columns like name and commission for all the salesmen.

Test your Programming skills with w3resource's quiz.

What is the difficulty level of this exercise?



Share this Tutorial / Exercise on : Facebook and Twitter

SQL: Tips of the Day

Can a foreign key be NULL and/or duplicate?

First remember a Foreign key simply requires that the value in that field must exist first in a different table (the parent table). That is all an Foreign key is by definition. Null by definition is not a value. Null means that we do not yet know what the value is.

Ref: https://bit.ly/3uVu3OS