How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / flitchner
select name from (select max(sal) as salary from emp) a,
emp b
where a.salary = b.sal;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to create tables for odbc connection testing?
what are actual and formal parameters?
How to rename an index?
What is Undo Management Advisor in Oracle?
How to create a table index?
How will you identify oracle database software release?
How index is implemented in oracle database?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How many categories of data types in oracle?
How to convert character types to numeric types?
defination of bitmap index
What is a tns file?
How to bring a tablespace online?
What happens to indexes if you drop a table?
Explain the truncate in oracle?