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 11779What 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 16792what 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 7141Suppose 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 5311DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
1 5301in 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 4017Parm 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 6670Post New IBM DB2 Interview Questions
How do concrete pumps work?
Write a query to find the names of users that begin with "um" in sql?
Explain TestSetup annotation?
What are the features of Pseudo mode?
How do dynamic websites work?
What is primary key and example?
what is more important to you: the money or the work at videocon?
How do you configure SharePoint to work with CRM 2011?
WHAT KIND OF LIGHTENING PROTECTION SCHEMS CAN BE ADOPTED FOR THE FLAT ROOF OF BIG DIMENSION.
How do you convert a string to in python?
1. How do declare public variable in vb scripts?
How to genrate report in wordpress cms
Is ubuntu completely open source?
What is the difference between equity and asset?
Explain four-tier connection?