Sandeep Kumar
What is sub-query ?
By Sandeep Kumar in Databases & DBA on Sep 29 2015
  • Naresh Tottempudi
    Mar, 2018 1

    A query with in the another query called subquey. Inner query executed first and the result will pass to the outer query. Outer query executed based on result given by inner query.

    • 1
  • Gajendra Jangid
    Jan, 2018 29

    A Subquery is a query within another SQL query and embedded within the WHERE clause.

    • 1
  • Sanjeev Kumar
    Jul, 2016 29

    A select statement return to another select statement is called Subquery

    • 1
  • Khajahaneef Shaik
    Jun, 2016 5

    With in the from cluase write a select or update or delete operation perfom that is sub querywith in the query call a another query is nothing but sub query

    • 1
  • Thiruppathi R
    Jun, 2016 1

    Sub-query is part of main query and first execute sub-query this output going to input of main query.

    • 1
  • Keerthi Venkatesan
    May, 2016 23

    A subquery is a SQL query within a query.Subqueries are nested queries that provide data to the enclosing query.Subqueries can return individual values or a list of records Subqueries must be enclosed with parenthesis

    • 1
  • Keerthi Venkatesan
    Apr, 2016 20

    sub query is also known as nested query. the query within another query using WHERE clause

    • 1
  • Jayesh Vaghasiya
    Mar, 2016 5

    Sub query is the query that is written within another query and its output serves as input to outer query . like 2 tabal ----emp_mst and emp_d_mast emp_mst ----emp_id p.key and emp_name emp_d_mst -----emp_id f.key and emp_salary then select emp_salary from emp_d_mst where emp_id = (select emp_id from emp_mst where emp_name = "jay pathak")

    • 1
  • Rajeev Punhani
    Jan, 2016 27

    Sub query is the query that is written within another query and its output serves as input to outer query .

    • 1
  • bharat aggarwal
    Jan, 2016 6

    a subquery is also called an INNER QUERY or INNER SELECT. the main query that contains the subquery is also called the OUTER QUERY or OUTER SELECT.

    • 1
  • bharat aggarwal
    Jan, 2016 6

    a subquery is also called an INNER QUERY or INNER SELECT. the main query that contains the subquery is also called the OUTER QUERY or OUTER SELECT.

    • 1
  • bharat aggarwal
    Jan, 2016 6

    a subquery is also called an INNER QUERY or INNER SELECT. the main query that contains the subquery is also called the OUTER QUERY or OUTER SELECT.

    • 1
  • bharat aggarwal
    Jan, 2016 6

    a subquery is also called an INNER QUERY or INNER SELECT. the main query that contains the subquery is also called the OUTER QUERY or OUTER SELECT.

    • 1
  • bharat aggarwal
    Jan, 2016 6

    a subquery is also called an INNER QUERY or INNER SELECT. the main query that contains the subquery is also called the OUTER QUERY or OUTER SELECT.

    • 1
  • Sandeep Kumar
    Sep, 2015 29

    Query inside query is known as sub-query.There will be two query inner query and outer query.In which inner query get execute first then outer query get executed

    • 1
  • Sreekanth Reddy
    Oct, 2018 23

    Sub-query is a query which provides result to the outer query.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS