70-461 Microsoft Exam Question  


New Member
Joined:3 months  ago
Posts: 1
03/04/2019 2:28 am  

Hello eveyone,

I took 70-461 Querying Microsoft SQL Server exam last week.  There is a question that I did not understand. There is a part of query below. We must complete it. The Question is;


You have a SQL Server database that contains all of the sales data for your company.

You need to create Transact-SQL has bee provided in the answer area below. Enter the code in the answer area that resolves the problem and meets the satated goals or requirements. you can add code within the code that has been provided as well as 


1   SELECT CustomerId, N 

2           , Top5=        (0.95)         (ORDER BY N)  OVER (PARTITION BY Sales)

3   FROM Customers  


There is also a lot of dump that has explanation of this question.  The aswer is below.  But I did not understand. Is there anyone who can explain  this syntax and answer? 


1   SELECT CustomerId, N, 

2     Top5=  TOP (0.95) PERCENT  Sales (ORDER BY N)  OVER (PARTITION BY Sales)

3   FROM Customers  


Thank you

PrepAway - Latest Free Exam Questions & Answers

Please Login or Register