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 Lock table in SQL?

1521

What is partition, how will you implement it? : sql server analysis services, ssas

1103

What is executereader?

1005

What's the information that can be stored inside a bit column?

1071

How to perform backup for certificates in sql server? : sql server security

1145

Define tempdb database?

1043

How to disable triggers using "disable trigger"?

1112

What stored by the tempdb ? : sql server database administration

1098

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

1161

Write a program using SQL queries to find a unique entry in a table.

1048

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1097

wat wil hapn if we give the both read and deny read permission to user?

2151

Why can there be only one clustered index and not more than one?

1042

Explain full-text indexing?

1045

What is the difference between executequery () and executeupdate ()?

1113