CODEWITHSUNDEEP
sqlsql-server
sripriya
sripriya

Reputation: 131

How to find consolidate top 10 employee in sql server

i have a larger database its imported SQL server i having many columns names like Employee , Transaction date, Approved date, Converted USD, . my Database Looks like 

Employee   Approved  ConvertedUSD
  Gayu        YES         25
  susi        YES         05
  Menu        YES         25
  Susi        YES         15
  Gayu        YES         20

employee repeated many times table . i want final output looks like 

 Employee   Approved  ConvertedUSD
      Gayu        YES         45
      susi        YES         20
      Menu        YES         25

how to consolidate in SQL then how i will find top 10 employees from table ?

Upvotes: 0

Views: 58

Answers (1)

Zaynul Abadin Tuhin
Zaynul Abadin Tuhin

Reputation: 31991

use aggregation and top keyword

select top 10 Employee,max(Approved),sum(ConvertedUSD) from table_name
group by Employee
order by sum(ConvertedUSD) desc

Upvotes: 4

Related Questions