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
62240 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 / sanjeev aggarwal

plz reply me at

sanju.agg@gmail.com

Is This Answer Correct ?

1 Yes

0 No

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

Answer / harish

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / vijay

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

Is This Answer Correct ?

6 Yes

6 No

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

Answer / xyz

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / madhu sudhan g

select Distinct * from dbo.EMP X
INNER JOIN dbo.EMP Y ON X.salary=Y.salary
AND X.ENAME<>Y.ENAME

Is This Answer Correct ?

0 Yes

0 No

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

Answer / asit

Can someone answer to this. on below query where i want to find same salary in employee table,

SELECT * FROM EMPLOYEE WHERE (SAL IN (SELECT sal FROM empLOYEE GROUP BY sal HAVING COUNT(sal) > 1))

i am getting correct output.

but if i change it to 'COUNT(SAL)>=1' then it prints all the lines from the table.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sanjeev aggarwal

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??

Is This Answer Correct ?

2 Yes

4 No

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

Answer / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Is This Answer Correct ?

1 Yes

4 No

Post New Answer