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 / prasanna
select *from emp where salary between 1000 to 50000
Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What is access path in db2?
What is db2 look?
Explain the function of data manager.
How do I delete a table in database?
How do we specify index to include or not during bind process.
How to check last update on table in db2?
Explain dclgen.
What do you mean by storage group (stogroup)?
How connect db2 database to datastage?
What is the difference between oracle and db2?
List out the data types available.
What is database reorganization?
What is a plan and package in db2?
How do I start db2 in windows?
What is syscat in db2?