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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / durga prasad

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

Answers were Sorted based on User's Feedback

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

Answer / sunil

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

Is This Answer Correct ?

72 Yes

16 No

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

Answer / vinay singh

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

**Vinay Singh
**9867774724

Is This Answer Correct ?

45 Yes

5 No

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

Answer / aashish mangal

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

Is This Answer Correct ?

17 Yes

3 No

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

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

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

Answer / ravi

sunil is correct...

Is This Answer Correct ?

9 Yes

2 No

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

Answer / vidyalakshmi.s

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

Is This Answer Correct ?

6 Yes

0 No

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

Answer / raghuvir

Select *from Emp_table where salary=20000

will display all the employees who have salary 20000

Is This Answer Correct ?

30 Yes

26 No

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

Answer / dilip

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

Is This Answer Correct ?

28 Yes

24 No

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

Answer / gangi naidu.k

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

Is This Answer Correct ?

6 Yes

2 No

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

Answer / antony

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

Is This Answer Correct ?

6 Yes

3 No

Post New Answer