Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14162 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
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
what is the role of the cursor in db2?
What is cursor with hold option in db2?
What is table space in db2?
What is bufferpool in db2?
What is the syntax for creating a table in the db2 database?
What is the difference between using bind () and rebind () methods of naming class?
Which component is responsible for db2 startup and shutdown?
Give a brief description of db2 isolation levels?
How to check table size in db2 sap?
Why cursor is used in db2?
What is a storage group (stogroup)?
How is the value function used?
What does a deadlock mean in DB2?
What is the usage of open cursor command?
