C# Corner
Tech
News
Videos
Forums
Trainings
Books
Events
More
Interviews
Jobs
Live
Learn
Career
Members
Blogs
Challenges
Certifications
Bounties
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
Java
Learn iOS Programming
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
16
Reply
What is sub-query ?
Sandeep Kumar
10y
2.9k
1
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
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.
Naresh Tottempudi
7y
1
A Subquery is a query within another SQL query and embedded within the WHERE clause.
Gajendra Jangid
7y
1
A select statement return to another select statement is called Subquery
Sanjeev Kumar
9y
1
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
Khajahaneef Shaik
9y
1
Sub-query is part of main query and first execute sub-query this output going to input of main query.
Thiruppathi R
9y
1
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
Keerthi Venkatesan
9y
1
sub query is also known as nested query. the query within another query using WHERE clause
Keerthi Venkatesan
9y
1
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")
Jayesh Vaghasiya
9y
1
Sub query is the query that is written within another query and its output serves as input to outer query .
Rajeev Punhani
9y
1
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.
bharat aggarwal
9y
1
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.
bharat aggarwal
9y
1
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.
bharat aggarwal
9y
1
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.
bharat aggarwal
9y
1
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.
bharat aggarwal
9y
1
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
Sandeep Kumar
10y
1
Sub-query is a query which provides result to the outer query.
Sreekanth Reddy
7y
0
Message