HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
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
How to return the second 5 rows in ms sql server?
What is a system database and what is a user database?
What is the maximum rows in sql server table?
What are page splits?
How to transfer a table from one schema to another?
What is conditional split?
What is data set in report?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
Can we perform backup restore operation on tempdb? : sql server database administration
What are the different authentication modes in sql server? How can it be changed?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Difference between Logical Page and Physical Page in SSRS.
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is user defined datatypes and when you should go for them?
What is the purpose of the model database?