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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / murtaza
select empname,salary from A
where empname IN ('A','B');
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
Answer / zaheer abbas
select empname ,salary
from A
where salary <= 2000
order by empname
Is This Answer Correct ? | 6 Yes | 6 No |
Answer / rajkumar
select*from emp where empname in ('A','B') order by empname
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / vinay
select empname , salary
from A
where empname in (select name from A group by empname
having count(empname ) > 1)
order by empname
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / anand
select empname,salary from tableA where(empname in (select
empname from tableA group by empname having count(empname)
>1))order by empname
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / kuntal
select * from A where empname in (select empname from A
group by empname having COUNT(*)>1)
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / goutam dey
select empname,salary from tableA
groupby empname
having count(empname)>1
Is This Answer Correct ? | 3 Yes | 7 No |
Answer / inderpal
Select empname, salary from A order by empname
Is This Answer Correct ? | 1 Yes | 5 No |
How do you clear a log file?
Do you know hot add cpu in sql server 2008?
What are the different SQL Server Versions you have worked on?
How to link up the text file to a Database table?
What does COMMIT command do?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is the maximum size of a row in sql server?
What are the type of Indexes? which one is best, why?
Explain what are magic tables in sql server?
How can i Relate Tables in SSIS
How to view the error log for any specific instance? : sql server database administration
What is de-normalization and when do you do it?