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

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

Question Posted / dilip

Answer Posted / dilip

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

Is This Answer Correct ?

28 Yes

24 No

Please Help Members By Posting Answers For Below Questions

What is pivot and unpivot?

978

What is a db view?

856

What are the properties of the transaction?

969

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1088

What is the order by used for?

966

What is table level trigger?

952

What are the ways available in sql server to execute sql statements?

1041

What does it mean if @@cursor_row returns a negative number?

943

How many levels of sp nesting are possible?

961

What is etl - extraction, transformation, and loading?

860

What are the types of processing and explain each? : sql server analysis services, ssas

1110

What is #table in sql server?

1001

what is package and it uses and how can u call a package

1955

What is user-defined functions? What are the types of user-defined functions that can be created?

981

What is executereader?

898