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
- 16090 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 |
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Describe the types of sub query?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Differentiate between pre-select and pre-query?
What are the differences between date and timestamp in oracle?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is the data pump import utility?
When do we use group by clause in a sql query?
What to do if the startbd.bat failed to start the xe instance?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
Explain the use of full option in exp command.
List out the difference between commit, rollback, and savepoint?
Oracle General 
