Select *from Emp_table where salary=20000

will display all the employees who have salary 20000

SELECT * FROM  EMP WHERE (SAL = (SELECT sal
 FROM emp GROUP BY sal HAVING COUNT(sal) > 1))

SELECT * FROM  EMP WHERE (SAL IN (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))

sunil is correct...

Select * From Employee 
Where Salary in 
 (Select Salary  From Employee Group by  Salary  Having    
           Count(Salary ) > 1)    

**Vinay Singh
**9867774724

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

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

If there are two salaries are same in a single table then 
what we do??
example:-

id    salary
s1    1200
s2    1500
s3    1200 
s4    1500
s5    1800

now what query we used??

plz reply me at

sanju.agg@gmail.com

select * from emp1 where salary in (select salary from emp1 
group by salary having count(salary) >1)

select A.id,A.salary from employee  A inner join employee B
on A.salary = B.salary and A.id <> b.id

select distinct A.id,A.salary from employee  A,employee B
where A.salary = B.salary and A.id <> b.id;

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

SELECT TOP (3)with ties empsalry 
    FROM empsalr
        
order by empsalry desc;

select e1.First_name,e1.salary from emp e1,emp e2 where 
e1.ROWID <> e2.ROWID and e1.salary=e2.salary;

Vinay Singh, are apna naam kyun kharab kar rahe ho boss.
Sunil ki query ko modified kar ke reply karate ho.