Which SQL statement should you use?

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?

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?

A.
Option D

B.
Option C

C.
Option B

D.
Option A



Leave a Reply 0

Your email address will not be published. Required fields are marked *