Oracle what is true abt Having and subQuery?

2012-03-14  Source: Original Site  Category:Oracle  Views:0 

Advertisement

what is true about having clause?

HAVING clause can be used to restrict both rows and groups. OR
HAVING clause can be used to restrict groups only.

What is true about subquery?

A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query’s FROM clause.

Related articles