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

What is self contained scalar sub query?

1021

How to enter comments in transact-sql statements?

991

How to create a dynamic cursor with the dynamic option?

1109

What command must you use to include the not null constraint after a table has already been created?

1241

What happens when converting big values to integers?

1061

Explain what is cte (common table expression)?

1191

Explain how would you store your query in an SSRS report or a Database server?

136

Explain aggregate functions?

1143

What do you mean by data manipulation language?

1065

How can i Relate Tables in SSIS

1136

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1036

how to overcome kernel isssues

1687

What is the openxml statement in sql server?

1126

How much does sql server 2016 cost?

1163

How to create a view using data from another view?

998