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

Give me a SQL Query to find out the second largest company?

1175

How to delete exactly duplicate records from a table?

1072

How can you set the threshold at which sql server will generate keysets asynchronously?

1001

What is a view in sql?

982

How to define and use table alias names in ms sql server?

1150

What is the difference between indexing and hashing?

1181

How to use “drop” keyword in sql server and give an example?

1140

What is the latest version of microsoft sql server?

1059

What is a trigger in sql server?

1188

Tell me when is the update_statistics command used?

1129

How do I find the default sql server instance?

952

Can we use custom code in ssrs?

1126

How many triggers are possible per table?

1109

What is inner join in sql server joins?

1051

What is ems sql management studio? : sql server management studio

1118