select * from tab where max(salary)

select max(sal) from <tablename>
if this answer not correct plz give me commets on the answer

Select * from table1 where salary = (select max(salary) 
from table1)

SELECT MAX(columnName1)
FROM Employee

select max(salary) from tablename

hi,, it work 


select * from table where salary =(select max(salary) from
table)    .......this returns whole record of that salary,,,,
an if u want just that maximum salary than



select max(salary) from table