select * from emp where emp=(select sal from emp group by sal having coun

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

Question Posted / gangi naidu.k

Answer Posted / gangi naidu.k

select * from emp where emp=(select sal from emp group by
sal having count(sal)>1)

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is policy management?

932

What is global temp table?

944

What are parameterized reports?

191

How to test values returned by a subquery with the in operator?

1130

How to find the version of sql server? : sql server database administration

1044

What is the current limitation of the size of SQL Azure DB?

124

What is identity?

947

How to create view in stored procedure sql server?

957

Which trace flags are enabled in sql server?

939

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

919

How to use transact-sql statements to access the database engine?

996

How do I create a partition table in sql server?

1046

Mention the different authentication modes in sql server.

960

Why the trigger fires multiple times in single login?

1152

What is Cross Join and in which scenario do we use Cross Join?

973