6 .You are a database developer and you have many years experience in database development. Now you are employed in a company which is named Loxgo. The company uses SQL Server  2008  and all the company data is stored in the SQL Server  2008  database. Now you company appoints you to serve for a charity organization which is named AngelPlan. According to the requirement of the charity organization, they want to view the highest  100  different amounts that were donated. So you are writing a query to list the  100  amounts. You have written the code segment below. (Line numbers are used for reference only):
 1  SELECT *
 2  FROM (SELECT Customer.CustomerID, SUM(TotalDue) AS TotalGiven,
 3 
 4  FROM Customer
 5  JOIN SalesOrder
 6  ON Customer.CustomerID = SalesOrder.CustomerID
 7  GROUP BY Customer.CustomerID) AS DonationsToFilter
 8  WHERE FilterCriteria <=  100 
In order to complete the query, you have to insert a Transact-SQL clause in line  3 
Which Transact-SQL clause should be inserted?
A: ROW_NUMBER() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
B: DENSE_RANK() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
C: RANK() OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
D: NTILE( 100 ) OVER (ORDER BY SUM(TotalDue) DESC) AS FilterCriteria
Correct Answers: D