What are the Properties of Sub-queries?

Properties:

  • 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 

Happy Reading  :-) 

Leave a Reply

Your email address will not be published. Required fields are marked *