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

What are the limitations in ssrs on sql server express edition?

133


How do I find sql server instance name?

484


Can sql servers linked to other servers?

526


What are the steps you can take to avoid “deadlocks”?

501


How do I setup a local sql server database?

512






What is a full text index?

473


What are the two modes of authentication in sql server?

500


What is forward - only cursors / read only cursor?

504


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

500


Can you tell me some of the common replication dmv's and their use? : sql server replication

518


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

524


What is bookmark link in ssrs?

108


Which are the important points to note when multilanguage data is stored in a table?

492


What is the difference between insensitive and scroll cursor?

553


Give an example of why you would want to denormalize a database

494