select A.id,A.salary from employee A inner join employee B on A.salary =

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

Question Posted / aashish mangal

Answer Posted / aashish mangal

select A.id,A.salary from employee A inner join employee B
on A.salary = B.salary and A.id <> b.id

Is This Answer Correct ?

17 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are indexers?

1036

What do you mean by normalisation?

964

What is the Control Flow in SSIS

1033

Can you explain what are various ways to enhance the ssrs report?

956

What happens when transaction log is full?

873

What is mean by dml?

945

How do I find the sql server instance name?

922

How can you ensure that the database and sql server based application perform well?

1015

Are semicolons required at the end of sql statements in sql server 2005?

934

Define views.

962

What is meant by Active-Passive and Active-Active clustering setup?

1069

What is inner join in sql server joins?

978

What are the differences between clustered and non-clustered index?

956

What is triggers and its types?

955

What are the difference between “where” and “having” clause in sql server?

1005