How to get single entry of empname from emp table for employee taking max salary

  • Interview Candidate
  • 6
  • 2097

Showing Answers 1 - 6 of 6 Answers

suresh kumar

  • May 23rd, 2006
 

select ename from(select * from emp order by sal desc) where rownum <=1;

  Was this answer useful?  Yes

Udit Agarwal

  • Jun 20th, 2006
 

 select emp_name from emp where e_salary=(select max(e_salary) from emp)

  Was this answer useful?  Yes

maqsood

  • Jul 10th, 2006
 

Select last_name from employees

Where rownum<=1

Order by salary desc

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions