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

What programming language would you use to create embedded functions in ssrs?

191

What is transaction server consistency?

1107

What are sp_configure commands and set commands?

1077

What are “unrepeatable reads”?

1300

what are different types of backups available in sql server? : Sql server database administration

985

Explain full-text query in sql server?

1054

What is an indice?

1085

Explain the phases a transaction has to undergo?

1115

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

What are various ways to enhance the ssrs report?

1035

How do I determine how many instances of sql server are installed on a computer?

1059

How to provide default values to stored procedure parameters?

1105

What is attribute? : sql server analysis services, ssas

1069

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

141

Does union all remove duplicates?

1123