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
- 15451 Views
- I also Faced
- E-Mail Answers
Answer Posted / niladri chatterjee
Select * From (Select * From Employee Order By Salary Desc) a
Where rownum=1 ;
Or
Select * From (Select Emp_id, Emp_NM, Salary From Employee Order By Salary Desc) a
Where rownum=1 ;
Based on Oracle 11g.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a subquery?
Explain the use of record length option in exp command.
Explain the use of record option in exp command.
How will you differentiate between varchar & varchar2?
What are the original export and import utilities?
How to export data with a field delimiter?
How to find the duplicate rows count from employees table in oracle?
query optmization techniques and quwry analyser+projects+ppts
How to select an oracle system id (sid)?
What is integrity and what is constraint??Explain with example
Explain the use of compress option in exp command.
 What are the oracle DML commands possible through an update strategy?
How to convert characters to times in oracle?
What is a trigger and what are its types?
What is an Oracle Instance?
