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 14180What 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 18612what 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 9010Suppose 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 6269DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
1 6106in 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 4822Parm 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 8185Post New IBM DB2 Interview Questions
What are the properties of the eventargs argument when capturing keyboard events?
What is model.cid ?
How to make a chain of function decorators?
How would you evaluate the performance of an NLP model?
Why triggers are used?
What is the full meaning of unix?
Differentiate between method overriding from method overloading with its functionality?
How to Move controls at runtime ?
What is the use of co-relation in jmeter?
How does php serialize work?
What is Freeform Pen Tool?
Do you know validations in laravel?
Why would you use xml?
What is the use of tools command?
In certain company 20% of the men and 40% of the women attended the annual company picnic. If 35% of all the employees are men .what % of all the employee went to the picnic?