This winter holiday season, give a precious gift to your career by upgrading your skills. | Get Flat 15 - 20% OFF on All Courses | Save Today

[iqquestion id=25]

5 thoughts on “Database : Database Operations Discussion 6

  • Pamela halbhavi

    A subquery is a query that is nested inside a Select, Insert, Update or Delete statement. It can also be inside another subquery. A subquery can return a set of rows or a single row to its parent subquery.
    example
    Update RECORDS
    set Name =’Alex’ where Name in(Select Name from RECORDS where Id = 01);

  • nasir

    Subquery is query within a query. This is used to ensure that the WHERE condition is further getting values from another query. The inner query executes first before its parent query so that the results of inner query can be passed to the outer query.
    Select employee_name, salary from employee where designation = (select designation from positionmaster where positioncategory like ‘%MANAGER%’)

  • collins

    a sub query is query inside a query like nasir said above the where condition it executes the select then the where

  • Olubunmi Ogunsola

    It is a query inside another query. An example would be select * from Players
    WHERE ID IN (Select ID FROM Players where goals > 15);
    – Tomiwa

  • sivi ramesh

    Sub query is the nested query.

Leave a Reply