What is subquery ?

Answer Posted / pooja intwala

A subquery is a SELECT statement within another SQL statement. The SQL statement can be SELECT, WHERE clause, FROM clause, JOIN, INSERT, UPDATE, DELETE, SET, DO, or another subquery.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

589


What are types of indexes?

592


What is performance tuning db2?

617


What is check constraint in db2?

603


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

712






How to create backup table in db2?

640


What is schema in db2?

574


What is page size in db2?

561


How is a typical db2 batch pgm executed?

641


What does db2 stand for?

596


Mention some fields that are a part of sqlca.

600


What are the prerogatives?

615


Explain about rct.

646


Mention the location where the output received from explain statement is stored.

628


What is bind and rebind in db2?

646