HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
- 18 Answers
- 64739 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are different types of roles provided by ssrs?
Does hive support indexing?
Explain the difference between delete,drop and truncate in SQL Server?
How many joins in sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Explain about link server in sql server?
What is a periodical index?
Explain the difference between HTTP and HTTPS in database?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Explain sql server service broker?
Describe and explain about SQL native client?
Tell me the phases a transaction has to undergo?
Can we call stored procedure in trigger?
What program is used to store the data source file?
What is a mixed extent?
