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
- 12358 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
Hi All
See the ques properly, he wants rows with salary bwtween
1000 to 5000. If one say between, it wont means inculsion
of 1000 and 5000 thus query will be
select * from employee where salary bwtween 1001 and 4999
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a storage group (stogroup)?
Explain various types of locks in db2?
How to connect to db2 database from windows command line?
How to execute stored procedure in db2 command editor?
Define buffer pool.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
define clustering index.
What is consistency token in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Explain package in db2 and its advantages?
Is db2 a mainframe?
Why do we use cursor?
What is db2 optimizer?
Explain the contents that are a part of dclgen.
