70-461 Microsoft Exam Question  

  RSS

New Member
Joined:2 weeks  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


ReplyQuote
PrepAway - Latest Free Exam Questions & Answers
  
Working

Please Login or Register