Select column value which coloumn value is max

Question

Shankar M · Answer

Hi Ankit,You can give a try to this one,SELECT TOP 1 * FROM tblEmployee ORDER BY SALARY DESCThanks,Shankar

AVADHESH PATEL · Answer

Hi Ankit!You can get name using nested query or sub query, as followingselect [name] from [tblEmployee] where [salary] = (select max(salary) from [tblEmployee])

forum

Select column value which coloumn value is max

Can you answer this question?

2 Answers