Explain Subquery and state its properties?

devquora
devquora

Posted On: Feb 22, 2018

 

Subquery – It is a query which is used when expressions are allowed and can be nested inside the main query like SELECT, UPDATE, DELETE or INSERT statements.
Properties:
  • A subquery in the main query that has to be placed on the right-hand side of the comparison operator
  • A subquery has to be placed parenthesis, in order to get executed first before the main query.
  • It cannot have any order by clause.
  • More than one subquery can be included in the main query.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Mssql Interview Questions

    What is MSSQL?

    MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

    Mssql Interview Questions

    What is SQL server agent and what are the two modes of authentication in SQL Server?

    SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..

    Mssql Interview Questions

    What is SQL Profiler?

    It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..