HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
- 18 Answers
- 64740 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
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 it’s similarity with sql server?
What is read committed?
What is the difference between grant and with grant while giving permissions to the user?
Do you know concepts and capabilities of sql server?
What is SQL Azure Firewall?
What are the 3 types of schema?
How to query multiple tables jointly?
Explain how to maintain a fill factor in existing indexes?
What do you understand by mirroring?
New concepts of sql server 2005 use in your project.
Define views.
where the connection string store in the database
How can you know if the row fetched from cursor is still valid in underlying table?
What are the differences between lost updates and uncommitted dependencies?
What is table value parameters (tvp)?
