How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / rohit
SELECT ENAME,SAL FROM EMP
WHERE ROWNUM = 1
ORDER BY SAL DESC
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Explain the difference between a procedure and a function? What do you understand by those terms?
What are the different oracle database objects?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How can we delete duplicate rows in a table?
What are the ways tablespaces can be managed and how do they differ?
How to create a new table in your schema?
How to convert characters to dates in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is the Tune Query
How to store pictures on to the database?
Please explain compound trigger in oracle?
How to get a list of all background sessions in the database?
How to find out what oracle odbc drivers are installed?
Is postgres faster than oracle?