select * from emp where (sal = (select sal from emp group by sal havi

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

Question Posted / vijay

Answer Posted / vijay

select *
from emp
where (sal = (select sal from emp
group by sal
having count(sal)>1))

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to rebuild indexes with alter index ... Rebuild?

1129

What is the difference between a function and a trigger?

1087

What are binary string data types in ms sql server?

1304

Which table keeps information about stored procedures?

945

How to sort the query output with order by clauses in ms sql server?

1036

optimization techinques

2681

What do you know about normalization and de- normalization?

931

How secure is sql server database?

1016

How you would rewrite the sql query to return the customerid sorted numerically?

1004

What is a virtual table in sql?

1003

What do I need to start working with sql studio? : sql server management studio

1122

Where is localdb stored?

947

What are the differences between substr and charindex in sql server.

1123

What are “unrepeatable reads”?

1241

Define msdb database?

1034