What techniques are used to retrieve data from more than
one table in a single SQL statement?

Answer Posted / obu

JOIN Statement

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster delete or truncate?

681


What is the maximum size of varchar data type in db2?

647


How to create backup table in db2?

648


Define sqlca.

651


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

633






Can you use max on a char column?

640


Mention the definition of cobol in varchar field.

700


What is a db2 cursor?

626


What is rct?

755


Give a brief description of db2 isolation levels?

606


What is load replace in db2?

562


What is null value in db2?

569


What is the physical storage length of date data type?

732


Explain in brief how does db2 determine what lock-size to use?

601


What is difference between isnull and coalesce?

622