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

How to rebuild the master database?

1065

How do I run sql server 2014?

968

How many primary keys are possible in a table?

911

How do you create a clustered index?

1035

In what version of sql server were synonyms released?

927

Explain comment on transactions?

963

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

969

What will be the maximum number of indexes per table?

942

what is denormalization? : Sql server database administration

911

Which are the important points to note when multilanguage data is stored in a table?

973

Where the sql logs gets stored?

967

What is the chart in report?

158

What is subquery? Explain the properties of a subquery?

963

Explain about temporary stored procedure?

993

Do you know the cursor types?

1145