select * from emp1 where salary in (select salary from emp1 group by sala

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

Question Posted / vidyalakshmi.s

Answer Posted / vidyalakshmi.s

select * from emp1 where salary in (select salary from emp1
group by salary having count(salary) >1)

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is table value parameters (tvp)?

1109

please differentiate between delete and truncate?

1000

How to join two tables in a single query in ms sql server?

1002

What is the difference between dataadapter and datareader?

1017

Define left outer join?

976

What is database white box testing?

1132

What are the different authentication modes in sql server?

1131

What is SQL Azure Firewall?

136

What is database black box testing?

1038

What is an example of a foreign key?

985

Do you know sql server 2008 backup compression?

975

Why functions are used in sql server?

967

How do you check sql server is up and running?

1007

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1149

What are the differences between stored procedure and the dynamic sql?

1102