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

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1067

What is difference between views and stored procedures?

927

Tell about MOM Tool(Microsoft Operator Manager)?

1854

What number sorts of privileges are accessible in sql?

978

What do you understand by mirroring and mention the advantages of the mirroring?

1008

Do you know what is difference between index seek vs. Index scan?

896

What is use of except clause?

1036

What the difference between UNION and UNIONALL?

984

Can truncate be rolled back?

884

What are audit control procedures?

939

What is the difference between DataRow.Delete() and DataRow.Remove()?

1165

What is the difference between for xml raw and for xml auto?

973

What are the types of resultset?

914

How to add an address record into adventureworkslt?

931

Explain acid?

1014