Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Describe a subquery ?

user-image
Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2015/01/07

A query that is nested inside a Select, Insert, Update and Delete statement or inside another subquery.

Naseef Pacheeri
by Naseef Pacheeri , Sales Support , Savola Group

  1. subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery. Asubquery can be used anywhere an expression is allowed. In this example a subquery is used as a column expression named MaxUnitPrice in a SELECT statement.

Muhammad Ashhar Hasan
by Muhammad Ashhar Hasan , Senior Software Engineer , Avanza Solutions

It is the query within a query and it could be of a single column (means the result of the Sub query must be a single column)

Tanay Das
by Tanay Das , IT Specialist , World Vision India

A Subquery is a query within another SQL query and included the WHERE clause. subquery returns data that will be used in the main query as a condition to further refine the data to be retrieved.

Zidiheri Al-amin
by Zidiheri Al-amin , Ass.Public relations officer , Timeless International

a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside, And it is always em-boded were clause.

a query within a query ora nested query is called a subquery

 

Syed Najam us Saqib
by Syed Najam us Saqib , Resident Engineer-Unix/Linux , Jaffer Business Systems (Pvt) Limited.

A Subquery or Inner query or Nested query is a query within another SQL query and embedded within the WHERE clause

Marva Clay
by Marva Clay , Promoter , Sashay Productions

A subquery is a query that is composed of two queries. The first query (inner query) is within the WHERE clause of the other query (outer query). In some cases the inner query provides results for the outer query to process. In other cases, the outer query results provide results for the inner query (correlated subquery).

Abdul Rasheed
by Abdul Rasheed , Testing Engineer , syntel

A query within a query called sub query. Sub query will be executed first then main query.

Mohamed Kaleel
by Mohamed Kaleel , IT Manager , Chemanol

Subquery which is nested inside a SELECT,INSERT,UPDATE , DELETE or inside another Subquery

Mohammad Yusuf
by Mohammad Yusuf , Manager, Healthcare Informatics (Healthcare & Imaging) , Aga Khan University Hospital

A subquery in any query language represents a complete query structure that is nested within an outer query structure.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.