Translate to Tamil

Earn Money


Best Offers

Amazon Best Offers

Offers

Best Online Offers

Amazon Offers

Earn Money Short URL

Wednesday, 5 January 2011

What are the properties and different Types of Sub-Queries?


PProperties of Sub-Query

1.     A sub-query must be enclosed in the parenthesis.

2.     A sub-query must be put in the right hand of the comparison operator, and

3.     A sub-query cannot contain an ORDER-BY clause.

4.     A query can contain more than one sub-query.


2.     Types of Sub-Query

1.     Single-row sub-query, where the sub-query returns only one row.

2.     Multiple-row sub-query, where the sub-query returns multiple rows,. and

3.     Multiple column sub-query, where the sub-query returns multiple columns


 Share This Post


No comments:
Write comments

Contact form

Name

Email *

Message *

Infolinks

© 2014