Query Output is : SQL> select *from emp where sal=any( select sal fro

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE

Question Posted / subbu

18 Answers
68363 Views
Infosys, TCS, I also Faced
E-Mail Answers

Answer Posted / subbu

Query Output is :

SQL> select *from emp where sal=any( select sal from emp
group by sal having count(sal)>1);

EMPNO ENAME JOB MGR HIREDATE
SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- -------
--- ---------- ----------
7521 WARD SALESMAN 7698 22-FEB-81
1250 500 30
7654 MARTIN SALESMAN 7698 28-SEP-81
1250 1400 30
7788 SCOTT ANALYST 7566 19-APR-87
3000 20
7902 FORD ANALYST 7566 03-DEC-81
3000 20

Is This Answer Correct ?

16 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain linked server in sql?

1228

Differentiate between delete and truncate.

1067

What do we need queues in sql service broker?

1072

How to create a view using data from another view?

954

Differentiate sql server reporting services vs. Crystal reports?

203

What is the difference between delete and truncate statements?

1085

Explain filestream storage of sql server 2008?

1024

What is model database in sql server?

1056

What are the events recorded in a transaction log?

1002

Explain sql delete command?

1062

What is truncate table?

947

What is federation member?

116

How will you add a dimension to cube? : sql server analysis services, ssas

1092

What is conditional split?

1087

Can we write trigger for view?

1016