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
12783 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 a performance monitor?

976

What is normalization 1nf 2nf 3nf?

1059

What is the difference between a function and a stored procedure?

1070

Why we should not use triggers?

963

What is database dimension? : sql server analysis services, ssas

1077

What is the use of commit?

999

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1965

Explain what are the different index configurations a table can have?

1109

What is a transact-sql statement batch in ms sql server?

1015

What is indexed view? How to create it?

1007

What is the size of transaction log file?

931

What are the difference between “where” and “having” clause in sql server?

1069

How to use linked server?

1191

What is rank function?

1028

Is it possible to have clustered index on separate drive from original table location?

967