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
- 12357 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
What are catalog tables in db2?
What is meant by explain?
what is the sqlcode -501
what is a corelated subquerry?
What is explain plan in db2?
What is performance tuning db2?
How do you select a row using indexes in db2?
How can you do the explain of a dynamic sql statement?
Why db2 is called db2?
What is difference between alias and synonym in db2?
What is runstats and reorg in db2?
can we view the access paths created by dbrm ? how ? thx
What are the various data types available in db2?
What happens in bind step in a db2 program?
Is db2 relational database?
