How do I add a column to a table in db2?
No Answer is Posted For this Question
Be the First to Post Answer
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What is the difference between nvl and coalesce?
What techniques will be used to avoid deadlock??
Describe what a storage group(STOGROUP) is?
Where is the access path logic created by the DB2 Optimizer stored?
What is phantom read in db2?
When can an insert of a new primary key value threaten referential integrity?
Can you Average the Characters ?
What is sqlcode -922 ?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
How does coalesce work?