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
- 15874 Views
- I also Faced
- E-Mail Answers
Answer Posted / pavan
select * from (select ename from emp order by rownuum desc)
where rownum=1;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Can objects of the same schema reside in different tablespace?
Explain what are clusters?
what are archived logs?
Is there any function in oracle similar like group_concat of mysql?
How to start your 10g xe server?
How to invoke the data pump export utility?
What exactly do quotation marks around the table name do?
How to write a left outer join with the where clause in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
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 is a database table in oracle?
Explain the use of show option in imp command.
How do I connect to oracle?
What privilege is needed for a user to create views in oracle?
