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


Please Help Members By Posting Answers For Below Questions

What is a cache in ssrs?

110


How to delete database objects with "drop" statements in ms sql server?

600


Can we perform backup restore operation on tempdb? : sql server database administration

594


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

688


What does Master database contains?

635






What number sorts of privileges are accessible in sql?

600


What is a system database and what is a user database?

585


Explain the flow of creating a cube? : sql server analysis services, ssas

631


How to execute stored procedure in select statement sql server?

541


Why can there be only one clustered index and not more than one?

551


What are cursors and when they are useful?

581


What are the different types of Indexes available in SQL Server?

527


What is NOT NULL Constraint in sql server 2012?

606


how to use DTS package in 2000,2005,2008 in sql server

1459


How to define the name and server for a new dsn?

555