Select emp.empname, emp.salary from employee emp join ( select empname, sa

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 / enis ertem

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

Answer Posted / enis ertem

Select emp.empname, emp.salary from employee emp join (
select empname, salary from employee emp
group by empname, salary
having count(empname) > 1) as tbl
on emp.empname = tbl.empname

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What kind of problems occurs if we do not implement proper locking strategy?

1468

Do you know what is blocking?

996

Define right outer join?

1016

What are the properties of the transaction?

1052

What does the update command do?

1173

Define normalisation?

1155

What is the difference between rank and dense_rank?

1166

Explain difference between cross join and full outer join?

1068

What is row_number()?

1053

What are system databases in ms sql server?

1126

What is difference between delete & truncate commands?

1146

How many replicas are maintained for each sql azure db?

124

What is database replication?

1210

How to assign null values to variables or columns?

1030

What is identity?

1083