select *from emp where max(sal)=dept;

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG
WITH DEPARTMENT NAMES? E.g EMP,DEPT

Question Posted / guest

5 Answers
10728 Views
College School Exams Tests, DELL, I also Faced
E-Mail Answers

Answer Posted / guest

select *from emp where max(sal)=dept;

Is This Answer Correct ?

2 Yes

16 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain mutating triggers.

1035

Is oracle an operator?

932

What do you know about normalization? Explain in detail?

957

Oracle

2381

How to invoke the original export import utilities?

1072

Is there a combination of "like" and "in" in sql?

1073

What is meant by joins? List out the types of joins.

1035

why dont we assign not null constraint as table level constraint.

2742

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1791

What is a trace file and how is it created in oracle?

1064

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2119

What is a subquery?

1129

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

2107

What are the differences between date and timestamp in oracle?

1055

How do I learn what codesets are available in oracle?

1045