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

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

10 Answers
12803 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / murtaza

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

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of lock supported by ?

1046

What are exact numeric data types in ms sql server?

1082

Explain transaction server consistency?

978

What are the 2 types of classifications of constraints in the sql server?

1125

Determine when an index is appropriate?

1078

What are the instances when triggers are appropriate?

979

What is difference between stored procedure and user defined function?

1113

What is the difference between web edition and business edition?

111

what's the information that can be stored inside a bit column? : Sql server database administration

1037

What is an indexed view?

961

How can you insert null values in a column while inserting the data?

1285

Do you know what is lock escalation?

1014

What is difference between clustered index and non clustered index?

1079

How you can move data or databases between servers and databases in sql server?

1054

What is command parameter in ssrs?

164