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

How many levels of sp nesting is possible?

1000

Explain transaction server consistency?

923

Which tcl commands are available on the sql server?

1018

Mention a few common trace flags used with sql server?

885

How you can get the list of largest tables in a database?

945

Why should we go for stored procedures? Why not direct queries?

1030

Do you know the capabilities of cursors?

1080

What does normalization do to data?

995

Write the SQL query to drop, truncate and delete table.

918

Tell me extended events in sql server 2008?

952

How to connect to a sql server using odbc_connect()?

1096

what protocol both networks use? : Sql server database administration

933

what is difference between NULL and ISNULL in SQL Server 2008?

967

what is isolation level at dead lock?

2093

How do I find the transaction log size in sql server?

921