Interested to Buy Any Domain ? << Click Here >> for more details...
i have an employment table whch has salary,dept,name? i want
salary b/w 1000 to 5000 can anyone pls say the query for ths ?
- 8 Answers
- 14395 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dinesh
option 1:
Select * from empoyment table where salary >=1000 and <=50000
option 2:
select * from employment table where salary between 10000 and 50000
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Mention some fields that are a part of sqlca.
What is cursor in dbms?
What is the role of schema in the db2 database?
How do you select a row using indexes in db2?
is it compulsory commitment control in journal?
What is a bind card?
List out the three types of page locks that can be held.
Is ibm db2 free?
What are foreign keys in db2?
What is ibm db2 database?
What is cursor with hold option in db2?
define clustering index.
How to find the number of rows in db2 tables?
Explain about rct.
Define check constraint.
