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 default schema of your login session in ms sql server?

1028

What happens if ntwdblib.dll is missing on your machine?

1127

What is row_number function?

976

How to provide default values to stored procedure parameters?

1039

What is the benefit of normalization?

1059

How do I find sql server instance name?

946

What is a transaction and why is it important?

1064

What is a subquery in a select query statement in ms sql server?

1114

What are system databases into sql server (2005/2008)?

985

How to create user messages with print statements in ms sql server?

970

How to create stored procedures with parameters in ms sql server?

1048

How to find the login name linked to a given user name?

990

How do I find the query plan in sql server?

938

Explain cursor as data base object?

1015

Explain different types of locks in sql server.

1064