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
- 10 Answers
- 10503 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
What is the use of keyword with encryption.
What are the different types of Indexes available in SQL Server?
how to overcome kernel isssues
What is the openxml statement in sql server?
List out the differences between global and local temp tables in sql server?
How to execute stored procedure and set temp table in sql server?
How many types of subqueries are there in sql server?
Is mysql better than sql server?
Explain following error properties?
What is the cartesian product of the table?
What are different types of roles provided by ssrs?
What is identity?
What is microsoft sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Can two different columns be merged into single column? Show practically?
