SELECT * FROM EMP WHERE (SAL IN (SELECT sal FROM emp GROUP BY sal HAVING

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

Question Posted / sunil

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

Please Help Members By Posting Answers For Below Questions

What is the difference between getdate and sysdatetime?

961

What is entity data services?

1020

What is partition, how will you implement it? : sql server analysis services, ssas

1007

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

861

role of sql sever 2005 in database rather than any other database

1898

What are ddl triggers and types of ddl trigger?

994

What is 1nf 2nf?

974

What is the difference between writing data to mirrored drives versus raid5 drives

882

What is sql server replication? : sql server replication

933

Define synonym?

1123

How to return the date part only from a sql server datetime datatype?

1045

Why is the need for data conversion transformations?

993

Why normalization is used?

974

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

904

what are candidate key, alternate key and composite key? : Sql server database administration

869