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
12805 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 is perspective, have you ever created perspective? : sql server analysis services, ssas

919

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1069

How to get @@error and @@rowcount at the same time?

1036

What are the differences between union, intersect, and minus operators?

1090

What are the restrictions applicable while creating views? : SQL Server Architecture

1029

How can we use ConnectorJ JDBC Driver with MS SQL?

1001

How to make a column nullable?

1122

How to use subqueries with the in operators in ms sql server?

1078

Why use triggers?

1017

Difference between Inner vs outer joins?

954

What is the process of normalization?

1127

What is indexed view? How to create it?

1014

in the physical file layout, where should the transaction log be stored in relation to the data file?

995

What are the encryption mechanisms in sql server?

1032

How to throw custom exception in Stored Procedure?

1045