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
- 16443 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
How to use in conditions in oracle?
Explain the use of rows option in imp command.
How can we create the complete backup of data in the oracle.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What privilege is needed for a user to delete rows from tables in another schema?
How to speed up webrick?
What is meant by recursive hints in oracle?
What is ceil and floor in oracle?
Can we save images in a database and if yes, how?
Why is oracle used?
how can we store any pdf file in oracle
What is instant client oracle?
What types of joins are used in writing subqueries?
What are the components of logical database structure in oracle database?
What are the attributes of cursor?
