Select * From Employee Where Salary in (Select Salary From Employee G

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

Question Posted / vinay singh

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

Please Help Members By Posting Answers For Below Questions

How to add an address record into adventureworkslt?

975

How can you ensure that the database and sql server based application perform well?

1055

What is BLOCK statements in SQL?

1251

What are the transaction properties?

999

List the advantages of using stored procedures?

1033

What are the properties and different types of sub-queries?

994

What is Service Broker in sql server 2012?

1010

How to rebuild the master database?

1067

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1130

What is snapshot replication?

1040

What are the differences between clustered and non-clustered index?

1007

How to write a query with a left outer join in ms sql server?

962

What are the types of ssrs?

145

Define Joins?

1012

Explain can SSRS reports Cache results?

158