What are the Properties of Sub-queries?
Posted in SQL Interview Questions, TSQL Interview Questions by Chandrasekhar Raparthi On August 31, 2016

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