Email: Password:       Forgot Password 
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
What is sub query and its properties?

Posted On: 02/07/2013 11:39:48
A sub-query is a query which can be nested inside a main query like Select, Update, Insert or Delete statements. This can be used when expression is allowed.

Properties of sub query can be defined as:

  1. A sub query should not have order by clause
  2. A sub query should be placed in the right hand side of the comparison operator of the main query
  3. A sub query should be enclosed in parenthesis because it needs to be executed first before the main query
  4. More than one sub query can be included 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us