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

Define a cross join?

598

What is the latest version of microsoft sql server?

488

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

583

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

615

What is transaction server auto commit?

579

What is the difference between composite index and covering index?

517

Explain what is the main purpose of having conversation group?

525

Write an SQL query to obtain the 2nd highest salary.

614

How to use values from other tables in update statements in ms sql server?

559

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

522

What are the steps to take to improve performance of a poor performing query? : sql server database administration

600

What do you mean by normalisation?

504

How can you insert values in multiple rows using one Insert statement?

621

What are the tables in sql?

632

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

560