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

What extended events?

956

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

885

What is the difference between dataadapter and datareader?

946

how many no of arguments can be passed in procedures and functions

5467

what is the system function to get the current user's user id? : Sql server database administration

957

Differentiate between delete and truncate.

999

Where sql server user names and passwords are stored in sql server? : sql server database administration

996

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

932

Explain about sql server login?

1032

When multiple after triggers are attached to sql table, how to control the order of execution?

982

What is user-defined functions? What are the types of user-defined functions that can be created?

981

Define candidate key, alternate key, and composite key.

874

When is update_statistics command used?

1000

What is clustered index

959

How to find which stored procedure is currently running in sql server?

927