CBSE Class 12 Informatics Practices Question 48 of 90

Querying Using SQL — Question 8

Back to all questions
8
Question

Question 8

The SQL statement : SELECT Salary + Comm AS Total FROM Emp; adds two fields salary and comm from each row together and lists the results in a column named Total.

Answer

True

Reason — The SQL statement SELECT Salary + Comm AS Total FROM Emp; adds the values of the Salary and Comm columns from each row together and lists the results in a column named Total. This is achieved by using the "+" operator to perform arithmetic addition on the values of the specified fields.