Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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 ?    54 Yes 11 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 ?    31 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 ?    15 Yes 1 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 ?    14 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 ?    8 Yes 2 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 25 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 23 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 ?    3 Yes 0 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

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 ?    4 Yes 1 No

Post New Answer



More SQL Server Interview Questions

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,


How to apply cascading referential integrity in place of triggers?

0 Answers  


how to know description of a table in sqlserver 2000

8 Answers  


Define master database?

0 Answers  






Can you explain what is sql server english query?

0 Answers  


How many types of the database links?

0 Answers   MCN Solutions,


How to override dml statements with triggers?

0 Answers  


What are the recovery models for a database?

0 Answers  


How to retrieve field values using mssql_result()?

0 Answers  


How to assign null values to variables or columns?

0 Answers  


Do you know the cursor optimization tips?

0 Answers  






Categories