select empname , salary from A where empname in (select name from A grou

Hi,

I have a table A which has four rows as follows

Table A
-------

empname salary
------- ------
A 1000
B 2000
C 3000
A 1000
B 2000
D 5000

I need the following output:

empname salary
------- ------
A 1000
A 1000
B 2000
B 2000

Thanks in advance

Question Posted / vinay

10 Answers
12692 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / vinay

select empname , salary
from A
where empname in (select name from A group by empname
having count(empname ) > 1)
order by empname

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between count (*) and count column?

879

What is the use of keyword with encryption. Create a store procedure with encryption?

946

What is local temp table?

934

What does COMMIT command do?

1037

What is the function of sql server agent windows service?

1068

What is a rownum?

947

Tell me what is de-normalization and what are some of the examples of it?

994

What are the differences between ms sql server & oracle?

1036

List down some advantages of sql stored procedure?

946

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

928

Explain the different types of joins?

969

What are the general features of sql server management studio? : sql server management studio

1060

How many instances per computer are there in sql server 2000?

1045

How do I install sql server?

875

What samples and sample databases are provided by microsoft?

1025