How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / hari.sidd
SELECT ENAME
FROM EMPLOYEE
WHERE ESAL=MAX(ESAL);
| Is This Answer Correct ? | 1 Yes | 12 No |
Post New Answer View All Answers
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
what is the difference between data migration and production migration.
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Please explain drop constraint oracle?
How to create a new oracle data file?
How can we delete duplicate rows in a table?
Which is faster join or subquery in oracle?
What is system tablespace?
How to connect to a local oracle 10g xe server?
What are joins, explain all types of joins?
How do I uninstall oracle 11g?
What privilege is needed for a user to create tables in oracle?
Where is the export dump file located?
What is using clause and give example?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....