What is subquery ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is subquery ?

A subquery is a subquery that is written as part of another query's WHERE clause. For example:
SELECT col_name1,col_name2
FROM table_A
WHERE col_name3 < ( SELECT Avg(col_name)
FROM table_A
WHERE col_name4 = 'constant' )

(Continued on next question...)

Other Job Interview Questions

• What is meant by repeatable read?
• What are the three tyes of page locks that can be held?
• How many sub queries can you combine together?
• What is the syntax of SELECT statement when embedded in a COBOL program ?
• What is isolation level?
• How do I create a table MANAGER ...
• How many sub queries can you combine together?
• Are view updatable?
• What is the easiest way to find out which programs are affected by change in a table's structure ??
• What is a DB2 bind?
• More...