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
- 11809 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rabindra mishra
Select * from employment table where salary >= 1000 and
>= 50000
It will work Faster then all the above queries
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
What is the use of commit in db2?
What does db2 blu stand for?
What is bind package and plan in db2?
What are the different types of base tables?
How do I change the column size in db2?
What is runstats and reorg in db2?
Explain how can you do the explain of a dynamic sql statement?
What do you mean by between and in? Is between inclusive of specified range values?
What is check constraint in db2?
What do you mean by rollback?
What are the uses of db2 optimizer?
What are catalog tables in db2?
What is the maximum size of varchar data type in db2?
What is netezza database?
What is innodb buffer pool?
