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 to list all stored procedures in the current database using ms sql server?
What is the optimization being performed in oracle and SQL Server?
What is the Difference Between Primary and Foreign Key?
0 Answers Accenture, Deloitte, JPMorgan Chase, Maveric,
Can we delete data from a view?
What is nonclustered index on computed columns?
How does stuff differ from the replace function?
How to execute multiple stored procedures at one time in sql server?
Explain about link server in sql server?
can an order by clause be used in a creation of a view?
What are the Pre Requisites when you apply Srvice Packs?
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?
What is ssl in sql server?