Question

Write a SELECT statement without a FROM clause that creates a row with these columns: Price 100 (dollars) TaxRate .07 (7 percent) TaxAmount The price multiplied by the tax Total The price plus tax To calculate the fourth column, add the expressions you used for the first and third columns.

Answer 1

Answer:

Select 100 AS Price

0.07 AS TaxRate

100*·07 AS TaxAmount

(100)+(100*·07) AS Total

Explanation:

The SELECT statement returns a Result Set of records from one or more table. In easy words, SELECT statement is used to select data from a database, the data returned is stored in a result table, called a Result Set.

A FROM clause can be pretty simple, it can be pretty complex. The thing to remember is that FROM clause produces a tabular structure. This tabular structure is the Result Set of FROM clause.

However, in this question, we have written a SELECT Statement without using the FROM clause .