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 

Happy Reading  :-) 

Latest Comments
  1. Saikrishna Papareddy

    Nice info

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.