select empname,salary from tableA groupby empname having count(empname)&g

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 / goutam dey

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

Answer Posted / goutam dey

select empname,salary from tableA
groupby empname
having count(empname)>1

Is This Answer Correct ?

3 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Determine when to use stored procedure to complete sql server tasks?

1033

Write down the syntax and an example for create, rename and delete index?

959

How to identify current user in ssrs report?

401

What is rs.exe utility?

156

What is data file in computer?

922

What is the primary use of the model database?

1064

what is create database syntax? : Sql server database administration

1083

What is database black box testing?

1012

Explain what is the function of sql server agent windows service?

974

What is sql service broker?

964

What is an expensive query?

912

What are types of subqueries?

1036

How to access the inserted record of an event?

1026

What is bulkcopy in sql?

931

What is the difference between left and right outer join?

1049