Select emp.empname, emp.salary from emp right outer join ( select empname,

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 / mohit kumar singhal

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

Answer Posted / mohit kumar singhal

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

Is This Answer Correct ?

8 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the default server name for sql server?

634

How to use subqueries with the exists operators in ms sql server?

584

Explain about service Broker functions?

613

Can a table be moved to different filegroup?

568

Explain powershell included in sql server 2008?

609

How much is a sql server license?

504

What are cascading parameters in ssrs reports?

176

Define synonym?

726

Define model database?

571

Detail about query optimizer?

609

What are the transaction properties?

547

How to find the login name linked to a given user name?

528

what is the Ticketing tool used in Wipro technologies at Bangalore...???

7474

What is a collation in ms sql server?

545

List out some of the requirements to set up a sql server failover cluster?

545