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

How to create a user to access a database in ms sql server using "create user" statements?

938

Which are ddl commands?

1029

Explain filtered indexes?

978

What is user-defined functions? What are the types of user-defined functions that can be created?

1020

What is the name of the system variable that returns the number of rows affected by a SQL statement?

996

What is the contrast amongst drop and truncate?

1029

Where views are stored in sql server?

965

What are the advantages of sql azure?

140

How to skip remaining statements in a loop block using continue statements?

982

How to list all schemas in a database?

1043

How can you insert null values in a column while inserting the data?

1252

What is the difference between a primary key and a unique key? Are they the same?

1062

What is efficiency data?

942

How to drop an existing table with "drop table" statements in ms sql server?

1068

If any stored procedure is encrypted, then can we see its definition in activity monitor?

968