select Distinct * from dbo.EMP X INNER JOIN dbo.EMP Y ON X.salary=Y.salary

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

Question Posted / madhu sudhan g

Answer Posted / madhu sudhan g

select Distinct * from dbo.EMP X
INNER JOIN dbo.EMP Y ON X.salary=Y.salary
AND X.ENAME<>Y.ENAME

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Tell me what are cursors and when they are useful?

959

What are data regions?

140

what is sql server? : Sql server database administration

997

Explain throw statement in sql server 2008?

1012

Explain Normalization and DE normalization

1119

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1037

How to check status of stored procedure in sql server?

994

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

889

How to copy the tables, schema and views from one sql server to another?

1054

What are drilldown reports?

158

Differentiate sql server reporting services vs. Crystal reports?

203

How do clustered indexes store data?

1112

What is data modification?

981

What is self join in sql server joins?

1067

What samples and sample databases are provided by microsoft?

1046