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
- 15654 Views
- I also Faced
- E-Mail Answers
Answer Posted / neha
select a.ename from (select ename from emp ORDER BY SAL
desc,ROWNUM DESC)a
where rownum=1;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to call a stored function with parameters?
What are the different oracle database objects?
Difference between oracle's plus (+) notation and ansi join notation?
How to export several tables together?
What are the database administrators utilities available?
How to write a query with a right outer join in oracle?
What is the data pump export utility?
How to define a procedure inside another procedure?
Explain index?
How do I spool to a csv formatted file using sqlplus?
How many types of auditing in Oracle?
Explain oracle 12c new features for developers?
When do I need to use a semicolon vs a slash in oracle sql?
what is the difference between data migration and production migration.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
