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 11815What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
3 16827what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
4 7162Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
1 5328DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
1 5333in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
1 4037Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
3 6681Post New IBM DB2 Interview Questions
what is the difference between embedded system and PLC. Whether the micro controller accept future expansion of program?
What is wrong with this program statement? void = 10;
Define sandbox.org. Name different sandbox types.
What is application context module?
What are pre and post-session shell commands?
What are the different dcl commands in sql?
What happens when a thread cannot acquire a lock on an object?
What does a drupal developer do?
What is guard in laravel authentication?
Explain the different ways in which solids can be blended?
Give examples of the Impact of Internet of Things (IoT) on our lives?
What is the global security?
I want to control database connections in my program and want that only one thread should be able to make database connection at a time. Define how can I implement this logic?
How do you select an exact color to match?
a sample of gas occupies a volume of {450.0 ml}at {740 mm Hg}and[16C]determine the volume of this same sample at [760 mm Hg]and [37c]?