3 lines
282 B
SQL
3 lines
282 B
SQL
SELECT SalesPersonID, Bonus FROM AdventureWorks.Sales.SalesPerson ORDER BY Bonus DESC;
|
|
SELECT TOP 4 SalesPersonID, Bonus FROM AdventureWorks.Sales.SalesPerson ORDER BY Bonus DESC;
|
|
SELECT TOP 4 WITH TIES SalesPersonID, Bonus FROM AdventureWorks.Sales.SalesPerson ORDER BY Bonus DESC; |