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 is the command used to recompile the stored procedure at run time?

1056

What is msdb database? : SQL Server Architecture

1111

What are different types of subquery?

1215

What is the purpose of floor function?

1021

What is the Main Difference between ACCESS and SQL SERVER?

1115

Define left outer join in sql server joins?

946

What is the ‘fillfactor’?

952

Can you pass expressions to function parameters?

1085

How to create a new login name in ms sql server?

1043

What is sparse columns of sql server 2008?

1030

What is a domain constraint give an example?

1029

What language is sql server written in?

1012

What do you mean by data integrity?

1046

What are the advantages of using stored procedures?

934

how many no of arguments can be passed in procedures and functions

5529