SELECT * FROM EMP WHERE (SAL IN (SELECT sal FROM emp GROUP BY sal HAVING

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

Question Posted / sunil

Answer Posted / sunil

SELECT * FROM EMP WHERE (SAL IN (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))

Is This Answer Correct ?

72 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Explain what is dbcc?

601

How to enable/disable indexes?

604

What is the difference between delete and truncate statements?

576

What is the downside of using udf?

570

How does clustered and non clustered index work?

522

Explain cross join or cartesian product in sql?

547

What is encryption key?

What is database architecture? : SQL Server Architecture

557

What is ms sql server triggers?

543

what is checksum in sql server.........???

1211

What is auditing in sql server?

509

Explain features and concepts of analysis services?

505

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

559

what is the difference between a primary key and a unique key? : Sql server database administration

535

What do you understand by the denormalisation?

555