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
12461 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 is extended stored procedures?

905

What is pessimistic concurrency?

924

What is the full form of ddl?

868

What are the types of database schema? : sql server analysis services, ssas

1072

What is partition in sql server?

978

State a few properties of relational databases?

1062

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

962

Mention the different authentication modes in sql server.

966

How many types of database relationship in sql server?

998

How to use transact-sql statements to access the database engine?

999

Explain log shipping and mention its advantages.

991

What is the report builder?

131

What is oltp (online transaction processing)?

953

What are the essential components of sql server service broker?

967

What is a document index?

981