HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
when would you go for denormalization? : Sql server database administration
What are the different types of indexes?
Explain data warehousing in sql server?
what is dbcc? : Sql server database administration
How to truncate a table first before running a package?
Explain Trigger with an example?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
How to provide Security for package?
How to check table values in sql server?
What is Full Outer Join?
What is dml command?
What is the importance of three tier architecture?