Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Describe a subquery ?

user-image
Question ajoutée par Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date de publication: 2015/01/07

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

Naseef Pacheeri
par 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
par 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
par 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
par 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
par 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
par 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
par Abdul Rasheed , Testing Engineer , syntel

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

Mohamed Kaleel
par Mohamed Kaleel , IT Manager , Chemanol

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

Mohammad Yusuf
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?