Writing Multiple Row Subqueries

Posted: Oct/07/2009 By: pankaj Points:15 Category: Oracle - Query Views:183 Vote Up (0) Vote Down (0)

A multiple row subquery returns one or more rows to the outer SQL statement.

The outer query may use the IN, ANY, or ALL operator to handle a subquery that returns multiple rows.

View Complete Post

Comments:

Be the first to comment this post.

Post Comment

Please login to post your comment

More Related Resources

Writing Single Row Subqueries

A single row subquery is one that returns zero or one row to the outer SQL statement.

You may place a subquery in a WHERE clause, a HAVING clause, or a FROM clause of a SELECT statement.