HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
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 |
Post New Answer View All Answers
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What does the update command do?
Can select statements be used on views in ms sql server?
How to test a dml trigger in ms sql server?
List out the differences between global and local temp tables in sql server?
why would you call update statistics? : Sql server database administration
What is proper subset of candidate key?
How to find table changes in sql server?
Define left outer join in sql server joins?
What is the purpose of object explorer and its features? : sql server management studio
What are a scheduled jobs or what is a scheduled tasks?
Can you move the resources after pausing the node? : sql server database administration
What are the types of normalization?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What do you understand by triggers and mention the different types of it?