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

Can you get second highest salary from the table?

543

Is foreign key unique?

567

What is the purpose of sql profiler in sql server? : sql server database administration

615

What is relationship? What number of sorts of relationship are there?

627

What is the difference between mysql and mysqli?

573

What is a schema in ms sql server 2005?

558

Which trace flags are enabled in sql server?

518

What are the difference between clustered and a non-clustered index?

580

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

1547

How does index makes search faster?

590

What is the partitioning method?

524

What is difference between count (*) and count column?

511

What is a view and what are its advantages?

682

What do you mean by 'normalization'?

595

How to implement service broker?

517