1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 / crprajan

Answers were Sorted based on User's Feedback



Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

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

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

Answer / murtaza

select empname,salary from A
where empname IN ('A','B');

Is This Answer Correct ?    3 Yes 2 No

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

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

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

Answer / zaheer abbas

select empname ,salary
from A

where salary <= 2000
order by empname

Is This Answer Correct ?    6 Yes 6 No

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

Answer / rajkumar

select*from emp where empname in ('A','B') order by empname

Is This Answer Correct ?    2 Yes 2 No

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

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

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

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

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

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

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

Answer / goutam dey

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

Is This Answer Correct ?    3 Yes 7 No

Hi, I have a table A which has four rows as follows Table A ------- empname salary ---..

Answer / inderpal

Select empname, salary from A order by empname

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More SQL Server Interview Questions

What are the different sql server versions?

0 Answers  

How do I save a stored procedure in sql server?

0 Answers  

explain different types of cursors? : Sql server database administration

0 Answers  

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  




what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

What is a DBMS, query, SQL?

0 Answers   Maveric,

What are the steps to insert a table?

0 Answers  

What is field in algebra?

0 Answers  

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

For more SQL Server Interview Questions Click Here
Categories