select distinct A.id,A.salary from employee A,employee B where A.salary =

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

Question Posted / antony

Answer Posted / antony

select distinct A.id,A.salary from employee A,employee B
where A.salary = B.salary and A.id <> b.id;

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is normalization according to you and explain its different levels?

949

Do you know how to store and query spatial data?

1038

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1263

Define clusters?

1075

Define inner join? Explain with an example?

996

Can I run multiple instances of sql server 2000 at the same time on one computer?

1074

How do you use a subquery to find records that exist in one table and do not exist in another?

1049

How to remove duplicate rows from table except one?

1007

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

Name some of the open source software that you can use in alternative to SSR?

161

How we can compare two database data?

945

How can sql injection be stopped? : sql server security

1033

What is the use of =,==,=== operators?

1013

How to turn off warning messages during php execution?

1044

Which is better statement or preparedstatement?

924