PrepAway - Latest Free Exam Questions & Answers

What should you add to the query?

You have a Microsoft SQL Azure database that contains a table named Customers. You have a table-valued
function named TopCustomers that returns a list of all the customers that have purchased items during the last
12 months. The ID of the customer is passed as an argument to the TopCustomers function.
You need to create a query that returns a list of all the Customer names and the purchase dates.
The solution must return only customers that have purchased an item during the last 12 months.
What should you add to the query?

PrepAway - Latest Free Exam Questions & Answers

A.
OUTER JOIN

B.
CROSS JOIN

C.
CROSS APPLY

D.
OUTER APPLY

One Comment on “What should you add to the query?


Leave a Reply