Select empname, salary from A order by empname

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

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

Answer Posted / inderpal

Select empname, salary from A order by empname

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of joins in sql?

1172

How to remove duplicate rows from table except one?

1064

What is dirty read?

1135

What is an expression in ms sql server?

1143

What is table-valued sub query?

1028

How to convert a table data in XML format in sql server?

2596

What is stored procedures?

1111

What do mean by xml datatype?

1176

Explain about service Broker functions?

1089

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1193

What is a with(nolock)?

1027

what are the core components of SSRS?

135

How to return the second 5 rows in ms sql server?

1108

How to modify the underlying query of an existing view?

1031

Do you know what is blocking?

996