select * from emp where emp=(select sal from emp group by sal having coun

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

Question Posted / gangi naidu.k

Answer Posted / gangi naidu.k

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

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

List the different types of joins?

947

Would you store your query in a ssrs report or a database server? State the reason why?

152

Can you explain about buffer cash and log cache in sql server?

915

What factors you will consider calculating the storage requirement for that view?

919

What is the difference between varchar and varchar(max) datatypes?

1023

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

990

What is in place upgrade in sql server?

1007

Is foreign key a primary key?

1010

What are the properties of the relational tables?

847

Explain encryption of entire databases without the need for application changes in sql server 2008?

1012

What is the difference between clustered and non-clustered indexes in ms sql server?

962

Explain about Normalization?

1027

New concepts of sql server 2005 use in your project.

2324

How to create a simple stored procedure in ms sql server?

993

Explain few of the new features of sql server 2008 management studio

875