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 are the indexes in sql server?

1026

What is transaction server consistency?

982

Explain the cursor lock types?

984

What is stretch database in sql server?

1028

Which table keeps information about stored procedures?

892

when would you go for denormalization? : Sql server database administration

813

What are the dis_advantages of stored procedures, triggers, indexes?

2173

What is advantage data architect?

869

What are the difficulties faced in cube development? : sql server analysis services, ssas

998

How to encrypt data between dialogs?

1033

Does transparent data encryption provide encryption when transmitting data across the network?

984

How do I setup a local sql server database?

948

Tell me what are the advantages of using stored procedures?

949

What is global temp table?

951

What are triggers in ms sql server?

1105