select empname ,salary from A where salary <= 2000 order by empn

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 / zaheer abbas

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

Answer Posted / zaheer abbas

select empname ,salary
from A

where salary <= 2000
order by empname

Is This Answer Correct ?

6 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the difference between delete,drop and truncate in SQL Server?

1164

What does it mean if @@cursor_row returns a negative number?

1040

Can you explain important index characteristics?

1032

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1385

What are indexers?

1134

What is a natural primary key?

1111

What is a trace frag?

1136

Which table keeps information about stored procedures?

985

Explain datetimeoffset data type in sal server 2008?

974

what is the primary use of the model database? : Sql server administration

1097

What is a primary index?

979

Why SQL Agent is used?

1204

What is difference between inner join and join?

1096

Explain features of analysis services?

1082

What is a virtual table in sql?

1037