Question

Write SQL statement to display the result of arithmetic expression 78 * 2 on screen

Answer 1

$\bf\large\underline\blue{Answer:-}$

SQL Arithmetic Operation

Arithmetic Operators

Arithmetic operators can perform arithmetical operations on numeric operands involved. Arithmetic operators are addition(+), subtraction(-), multiplication(*) and division(/). The + and - operators can also be used in date arithmetic.

OperatorMeaningOperates on+ (Add)AdditionNumeric value- (Subtract)SubtractionNumeric value* (Multiply)MultiplicationNumeric value/ (Divide)DivisionNumeric value% (Modulo)Returns the integer remainder of a division. For example, 17 % 5 = 2 because the remainder of 17 divided by 5 is 2.Numeric value

Syntax:

SELECT <Expression>[arithmetic operator]<expression>... FROM [table_name] WHERE [expression];

ParameterDescriptionExpressionExpression made up of a single constant, variable, scalar function, or column name and can also be the pieces of a SQL query that compare values against other values or perform arithmetic calculations.arithmetic operatorPlus(+), minus(-), multiply(*), and divide(/).table_nameName of the table.

Answer 2

Answer:

hloo mate..

here's ur answer...

according to me..

it may be

Select 78*2

simple.

hope it helps..