Writing Single Row Subqueries

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

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.

View Complete Post

Comments:

Be the first to comment this post.

Post Comment

Please login to post your comment

More Related Resources

Performing Single Table SELECT Statements

The SELECT statement retrieves information from tables.
The SELECT statement specifies the table and a list of column names.
After the SELECT keyword, you supply the column names.
After the FROM keyword, you supply the table name.
The SQL statement is ended using a semicolon (;).
The items that immediately follow the SELECT statement can be any valid expressions.
The rows returned by the database are known as a result set.
Oracle database converts the column names into their uppercase equivalents.
Character and date columns are left-justified.
Number columns are right-justified.

Writing Multiple Row Subqueries

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.