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

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

Question Posted / dilip

Answer Posted / dilip

SELECT * FROM EMP WHERE (SAL = (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))

Is This Answer Correct ?

28 Yes

24 No

Please Help Members By Posting Answers For Below Questions

What is the stored procedure?

1009

Explain the difference between clustered and non-clustered index?

923

How can we rewrite sub-queries into simple select statements or with joins?

981

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2070

Why and when do stored procedure recompile?

982

Explain time data type in sal server 2008?

924

Write a query for primary key constraint with identity key word?

1031

Explain the xml support sql server extends?

1042

How to delete a login name in ms sql server?

1076

Difference between Inner vs outer joins?

952

How does the report manager work in SSRS?

150

Can I run multiple instances of sql server 2000 at the same time on one computer?

1074

Ways to improve the performance of a SQL Azure Database?

125

Can we insert data if clustered index is disabled?

943

What are a database and a data warehouse?

1022