select ename from emp where sal in(select max(sal) from emp) and deptno i

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Question Posted / avinash

24 Answers
29501 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / avinash

select ename from emp where sal in(select max(sal) from
emp) and deptno in(10,20)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is faster view or stored procedure?

886

What plvcmt and plvrb does in pl/sql?

1247

How do you define a foreign key?

937

What are the different sql languages?

984

What is snowflake sql?

1010

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1072

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

897

What is the plv (pl/vision) package offers?

977

What is a schema? How is it useful in sql servers?

1041

How many types of indexes are there in sql?

932

how to create a new table in mysql? : Sql dba

932

Advantages and disadvantages of stored procedure?

1057

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3007

does sql support programming? : Sql dba

989

How can we avoid duplicating records in a query?

917