You have a table named SALES with the following columns:
SalesmanID | ProductsSold
1 | 2000
2 | 4000
3 | 5000
4 | 5000
5 | 6000
6 | 6000
7 | 9000
8 | 9000
You have to chose a query that will select all SalesmanIDs that have sold an amount of products within the 3 top ProductsSold values.
A. SELECT TOP(3) WITH TIES
SalesmanID, ProductsSold
FROM Sales order by ProductsSold
B. SELECT TOP(30) PERCENT
WITH TIES
SalesmanID, ProductsSold
FROM Sales order by ProductsSold
C. SELECT SalesmanID
From Sales where ProductsSold in (Select TOP 3 ProductsSold
From Sales)
D. Select TOP (3) ProductsSold, SalesmanID
From Sales
