You have a table named Sales that lists all of the products sold by your company. The Sales table contains a column named UnitsSold. UnitsSold contains the total number of units sold of each product. Each product appears in only one row. You have the following view:

You discover that the view does not return a list of the top 100 selling products. You need to ensure that the view returns a list of the top 100 selling products. Which SQL statement should you use?

Question

You have a table named Sales that lists all of the products sold by your company. The Sales table contains a column named UnitsSold. UnitsSold contains the total number of units sold of each product. Each product appears in only one row. You have the following view:

You discover that the view does not return a list of the top 100 selling products. You need to ensure that the view returns a list of the top 100 selling products. Which SQL statement should you use?

Accepted Answer

C. Option C

Answer

A. Option A

Answer

B. Option B

Answer

D. Option D

You have a table named Sales that lists all of the products sold by your company. The Sales table contains a column named UnitsSold. UnitsSold contains the total number of units sold of each…

Question

Exhibits

Options

How the community answered

Community Discussion