How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / srinu.g
select b.ename from emp b,(select max(sal) k from emp) a
where a.k=b.sal;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Difference between open_form and call_form in oracle.
What is snapshot is too old? Give and example for better understand.
What is a parameter file in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What are the different windows events activated at runtime ?
What is the difference between a hot backup and a cold backup in oracle?
Is it possible to split the print reviewer into more than one region ?
What is the parameter mode that can be passed to a procedure?
How can we create the complete backup of data in the oracle.
What is sequence?
How to Truncate Table in Oracle
How to build data dictionary view an new database?
What is a connect identifier?
How do I find the database name in oracle?
What is raw datatype?