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

Define normalisation?

1077

Explain what role entity and relationship play in an ER diagram.

1041

What information is maintained within the msdb database?

936

Distinguish between nested subquery and correlated subquery?

999

What is meant by indexing?

965

What is msdb database? : SQL Server Architecture

1086

What is a trigger in sql server?

1118

What are subqueries in sql server?

1080

What is a natural primary key?

978

What are the advantages of paper records?

927

How to count rows with the count(*) function in ms sql server?

973

Explain what are the database objects? : SQL Server Architecture

1033

What is stretch database in sql server?

1042

What are the advantages of using stored procedures in sql server?

981

What is key attribute?

889