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

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

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

Answer Posted / rajkumar

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

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the difference between primary key and unique key? : sql server database administration

993

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1107

How to execute a stored procedure in ms sql server?

1255

What is the purpose of linked server configuration in sql server?

1096

Explain the steps to use transact-sql cursor?

1157

How to create a simple table to test triggers in ms sql server?

1038

Explain nested trigger in sql?

1132

Why do you want to join software field as you have done your BE in Electronics?

2198

How to set the current database in ms sql server?

1145

What do you understand by integration services in sql server?

1003

We need to perform what steps in the following order to work with a cursor?

1275

What are the acid properties?

1060

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1087

What is data mart? : sql server analysis services, ssas

1111

What is a select query statement in ms sql server?

1132