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
How to create a new tablespace in oracle?
Write a trigger example in oracle?
Explain oracle insert into command?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to use "in out" parameter properly?
Describe varray?
What do you know about normalization? Explain in detail?
What is the difference between online and offline backups?
What to do if dba lost the system password?
What is a cursor in oracle?
How many anonymous blocks can be defined?
How to start instance with a minimal initialization parameter file?
What is the string concatenation operator in oracle?
What is ADDM Advisor in Oracle?
How to create a new oracle data file?