Hi,,,
id department salary
1 D1 1000
2 D2 2000
3 D3 3000
4 D1 2500
I want to select only which department offering more salary...I want Sql query for above concept
select top 1 deptname,sum(salary) from department group by deptname
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.