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 / 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 is db2 connect?
Is db2 a database?
What is the default page size of buffer pools?
What is dpf in db2?
Which command is used to remove all rows from a table?
Name the lockable units in DB2?
Mention the definition of cobol in varchar field.
What are foreign keys in db2?
What is db2 purescale?
What is explain in db2?
What r the comman abends in db2, jcl and cobol???????
What is cursor in dbms?
Which isolation level provides highest data integrity?
How to find schema of a table in db2?
What is collection in db2 bind?