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 a derived table?

937

How do you drop an index?

934

What are the differences between decimal and float in ms sql server?

1261

How do I install only the client tools of sql server 2000?

1073

Explain go command in sql server?

1049

What are the advantages of user-defined functions over stored procedures in sql server?

1055

Some queries related to SQL

991

What are the instances when triggers are appropriate?

988

How is SQL Azure different than SQL server?

225

What's new in sql management studio for sql server? : sql server management studio

1073

What are the characteristics of modern DBMS?

1106

What is the federation in sql azure?

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1056

What are differences in between sql server 2012 and sql server 2016?

1056

What are the dmvs? : sql server database administration

1076