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

Can binary strings be used in arithmetical operations?

943

Explain how many normalization forms?

1038

what is the difference between delete table and truncate table commands? : Sql server database administration

1047

How to use go command in "sqlcmd"?

1218

What should be the fill factor for indexes created on tables? : sql server database administration

1147

What are the fixed server level roles? : sql server security

1143

What is optimization and its types?

990

How many joins in sql server?

968

Why olap is used?

985

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1075

What are the types of stored procedures in an sql server?

995

What is a db view?

908

What is a database in ms sql server?

1068

What are the difference between primary keys and foreign keys?

975

What is log in sql server?

1156