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 ?
Answer Posted / dd
select salary from employment
where sal between 1000 and 5000
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
On which levels locks can be applied?
Which isolation level provides highest data integrity?
What is the difference between db2 and oracle?
What is dbrm? What it contains?
How does db2 sample database connect?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Discuss about db2 bind?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain various types of locks in db2?
What is the physical storage length of date data type?
What is sqlca?
What is a db2 tablespace?
How to check last update on table in db2?
What is the use of value function?
Define check constraint.