MCQs > IT & Programming > ASP.NET With SQL Server > It is time for the annual sales awards at your company. The awards include certificates awarded for the five sales of the highest sale amounts. You need to produce a list of the five highest revenue transactions from the Orders table in the Sales database. The Orders table is defined as follows:

ASP.NET With SQL Server MCQs

It is time for the annual sales awards at your company. The awards include certificates awarded for the five sales of the highest sale amounts. You need to produce a list of the five highest revenue transactions from the Orders table in the Sales database. The Orders table is defined as follows:

CREATE TABLE Orders (        

OrderID Int IDENTITY NOT NULL,       

 SalesPersonID Int NOT NULL,       

 RegionID Int NOT NULL,        

OrderDate Datetime NOT NULL,        

 

OrderAmount Int NOT NULL )

Which statement will produce the report correctly?

Answer

Correct Answer: SELECT TOP 5 OrderAmount, SalesPersonID FROM orders ORDER BY OrderAmount DESC

Explanation:

Note: This Question is unanswered, help us to find answer for this one

ASP.NET With SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

More ASP.NET With SQL Server MCQ Questions

search

ASP.NET With SQL Server Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it