select ename,max(sal)from emp group by ename

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / shan

Answer Posted / shan

select ename,max(sal)from emp
group by ename

Is This Answer Correct ?

0 Yes

8 No

Please Help Members By Posting Answers For Below Questions

how can we store any pdf file in oracle

2220

How to create additional tablespaces for an new database?

1078

What is hash cluster in oracle?

1245

Explain the use of tables option in exp command.

1166

Difference between open_form and call_form in oracle.

1223

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2872

How to check database size in Oracle?

1256

How to write date and time literals in oracle?

1044

What is transport network substrate (tns) in oracle?

1092

How to pass parameters to procedures?

1089

How to rename an index?

1124

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2148

What is a server parameter file in oracle?

1097

What are the restrictions on external table columns?

1109

Differentiate between post-database commit and post-form commit?

1092