select * from emp where (sal = (select sal from emp group by sal havi

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

Question Posted / vijay

Answer Posted / vijay

select *
from emp
where (sal = (select sal from emp
group by sal
having count(sal)>1))

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain the steps to create and execute a user-defined function in the sql server?

1016

What is scan table/view and seek table/view when its occurs? : sql server database administration

1088

What are the elements of dbms?

1010

What is it unwise to create wide clustered index keys?

1044

What are points to remember while using the fillfactor argument?

1018

What is an execution plan? When would you use it?

1026

What is data source document?

1089

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1044

What is a not null constraint?

1088

What is dirty read?

1135

What is difference between stored procedure and user defined function?

1170

How to use subqueries with the exists operators in ms sql server?

1178

State the difference between local and global temporary tables?

1166

What is checkpoint in sql server?

1215

How to get nth highest salary from employee table.

1206