Interested to Buy Any Domain ? << Click Here >> for more details...
How to select the name of employee who is getting maximum
sal with out using subquery
- 15 Answers
- 15441 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rushi
select ename from employee where sal=(select disinct(max(sal) from employee));
| Is This Answer Correct ? | 2 Yes | 8 No |
Answer / rohit
SELECT ENAME,SAL FROM EMP
WHERE ROWNUM = 1
ORDER BY SAL DESC
| Is This Answer Correct ? | 0 Yes | 7 No |
Answer / mk
select Name from emp where sal=(select distinct(Max(sal))
from emp
| Is This Answer Correct ? | 4 Yes | 14 No |
Answer / hari.sidd
SELECT ENAME
FROM EMPLOYEE
WHERE ESAL=MAX(ESAL);
| Is This Answer Correct ? | 1 Yes | 12 No |
How to invoke the original export import utilities?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the CAP theorem?
How to define a sub function?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
Define the terms primary key foreign key and also the difference between primary and the unique key
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Explain overloading. Can functions be overloaded?
How to update values on multiple rows in oracle?
What are the execution control statements?
How to increment dates by 1 in oracle?
Oracle General 
