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
12800 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

Define synonym?

1178

What is the purpose of the master database?

1131

Why use update_statistics command in sql server?

1060

How to select some specific columns from a table in a query in ms sql server?

1005

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

996

What are the different subsets of sql?

1552

Can you tell me about the concept of ER diagrams?

1081

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1089

List some advantages and disadvantages of stored procedure?

1016

How to get a list of columns in a view using "sys.columns" in ms sql server?

994

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2365

Can the “if update (colname)” statement be used in a delete trigger?

994

How can you hide the sql server instances?

1024

How do I install sql server?

894

What are different types of database indexes?

1104