Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10 Answers
- 12820 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
What is history table in sql server?
How will you optimize a stored procedure optimization?
What is use of except clause? How it differs from not in clause?
Explain about sql server login?
How to list all triggers in the database with sys.triggers in ms sql server?
What are the different types of replication are there in sql server 2000?
What are the different types of backups that exist?
What are dml triggers and types of dml triggers?
Do you know how to make remote connection in database?
What is named calculation? : sql server analysis services, ssas
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How to download and install sql server 2005 books online?
What is inline variable assignment?
Explain the purpose of indexes?
What do you mean by subquery?
