Wednesday, 11 September 2013

4. Display the top three sales persons based on the bonus. (Use the AdventureWorks database)

select * from sales.salesPerson
select Top 3* from Sales.SalesPerson
order by bonus desc

No comments:

Post a Comment