What is subquery ?

Answer Posted / v.chellappa

Usally subquery is executed first then result return to the
main query.
Based on the returned value the main querey is executed

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to compare data between two tables in db2?

658


What is the use of predicate?

584


What is concurrency?

709


How can you count the number of rows from a table tab?

633


define clustering index.

614






List down the types of triggers in the db2 database?

588


Can we update view in db2?

558


How to restart a DB2 program?

1361


What is query_cache_limit?

541


What is table space in db2?

576


How connect db2 database to datastage?

761


What is access path in db2?

562


What is the syntax for seeing the columns and data types of a table in the db2 database?

576


What is bind plan?

608


How do you eliminate duplicate values in db2?

683