HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE

Answer Posted / vinay singh

Select * From Employee
Where Salary in
(Select Salary From Employee Group by Salary Having
Count(Salary ) > 1)

**Vinay Singh
**9867774724

Is This Answer Correct ?    45 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we delete Duplicate row in table?

790


What are the types of table?

737


What stored by the master?

718


What is the difference between sdf and mdf?

973


What is the recovery model? List the types of recovery model available in sql server?

660






What are constraints in microsoft sql server?

739


What do you mean by data integrity?

786


How to list all objects in a given schema?

737


How do I create a stored procedure in dbml?

687


What is view in sql?

716


Can we use pragma autonomous_transaction in trigger?

704


Tell about MOM Tool(Microsoft Operator Manager)?

1596


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

862


What is the library index called?

775


How to generate create view script on an existing view?

743