How to get max salary in sql server?


To get the max salary from the Employee table you can use the Built-in function MAX in sql server.

EmployeeId EmployeeName Salary DepartmentId
1 Valiveti Sekhar 10000 1
2 Sai Kumar 10000 1
3 Dipti 18000 2
4 Suresh Kumar 10000 2
5 Raj Kumar 10000 2
6 Raj Kumar 11000 3
7 Manas Kumar 14000 3
8 Sanjiit 14000 4
9 Amit P 11000 2
10 Amit C 13000 1
Select MAX(Salary) From Employee;
Result:

18000

Share On