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

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

960

What are the essential components of sql server service broker?

967

What is the difference between local and global temporary tables?

1079

What is transact-sql ddl trigger?

1053

Do you know what is normalization of database? What are its benefits?

1033

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

952

Explain the disadvantages of cursors?

1054

Why we need to use secondry database file? though, we can do same work using primary database file also.

6759

What is user defined datatypes and when you should go for them?

967

Explain what are the events recorded in a transaction log?

938

How will you hide an attribute? : sql server analysis services, ssas

896

What are the pre-defined functions in the sql server?

1032

What stored by the master? : sql server database administration

1031

What are xml indexes?

895

What do you mean by sql server agent?

948