How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / atal patra
select ename,max(sal)from emp group by ename;
| Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
When do I need to use a semicolon vs a slash in oracle sql?
State the various uses of dbcc command?
What are the different types of failures that occur in Oracle database?
What is backup in Oracle?
Difference between inner join vs where ?
What is hot backup and logical backup?
How to check database size in Oracle?
Explain the use of consistent option in exp command.
Explain temporal data types in oracle
Please explain oracle left join with an example?
What are the most common interview questions on ETL Testing for experience?
What happens to the current transaction if the session is ended?
What is oracle rowcount?
What is the string concatenation operator in oracle?
Explain rename?