1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / rashmi_raju

Answer Posted / rashmi_raju

SELECT ename FROM emp WHERE sal =(SELECT MAX(sal) FROM emp
WHERE deptno=10)
UNION
(SELECT ename FROM emp WHERE sal =(SELECT MAX(sal) FROM emp
WHERE deptno=20))

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql procedural language?

564

How to execute a stored procedure?

571

how to shutdown mysql server? : Sql dba

578

what is a table in a database ? : Sql dba

556

what is index? : Sql dba

569




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

605

What is the difference between functions, procedures, and packages in pl/sql?

494

What is trigger price?

555

which tcp/ip port does sql server run on? : Sql dba

525

How to use transactions efficiently : transact sql

556

What is difference between inner join and cross join?

530

Is sql scripting language?

532

Is sql better than access?

551

Which sql most popular?

576

Determine if oracle date is on a weekend?

566