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
12688 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

Name and describe few console utilities for ssrs?

284

Do you know what are the restrictions that views have to follow?

1062

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1044

What are joins in sql and what are the different types of joins?

992

What is after dml trigger?

992

when you create a database how is it stored? : Sql server database administration

997

What is the difference between delete and truncate statements?

1058

How to execute a sql statement using mssql_query()?

1029

Why do we use non clustered index?

1060

Do you know nested transaction?

942

what is bit datatype? : Sql server database administration

896

Why truncate is ddl command?

1043

What is the use of RDBMS?

986

What is buffer cash in sql server?

1138

Explain what are commit and rollback in sql?

910