Translate to Tamil

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

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

Infolinks

Services

© 2014