What are the Properties of Sub-queries?
- We can use Order by only when we use TOP
- Text, ntext and Image types are not supported in the select list of the sub query
- We can’t update a view created by using a sub query
- Distinct keyword can’t be used in the queries that include Group By