answersLogoWhite

0


Best Answer

The main differencre between subquery and co-related subquery is that in subquery child query is executed first n then parent,but in co-related subquery main query is executed first(even though parenthesis are present) and then child query. Example of co-related subquery select dname from dept where exists

(select deptno from emp

where dept.deptno=emp.deptno); select dname from dept where not exists

(select deptno from emp

where dept.deptno=emp.deptno);

User Avatar

Wiki User

16y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are co related sub queries?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are nested transactions in MySQL?

Nested Transactions are transactions within transactions and are currently not supported by MySQL. Nested Transactions are not even vaguely related to Co-related Queries.


Forms of sub queries in ms sql?

Sql Forms Sql Forms


Want to become sub broker for reliance money in mumbai?

For any queries on taking sub brokership in maharashtra, call me on 9370014795.


What is option implicit in visual basic?

The Related Link will answer all your queries related to Visual Basic.


What is the chemical equation for the combustion of carbon dioxide?

the answer is CO(sub 2)+H(SUB 2)O


Queries are created specifically to gather HBSS related compliance data?

Queries in HBSS are designed to gather specific data related to compliance with security policies and best practices. These queries enable administrators to monitor and assess the state of compliance within their systems, helping to ensure that security measures are effectively implemented and maintained. By running these queries, organizations can proactively identify and address any vulnerabilities or non-compliance issues within their environment.


An SQL subquery can appear inside of another SQL subquery?

Yes, but more the levels of sub queries, the more would be the time taken to execute the query.


What are the subdivisions of Auschwitz?

Sub divisions means Sub camps of auschwitz Look at related linked


What has the author Rebecca Jane Heumann written?

Rebecca Jane Heumann has written: 'The impact of Co Sub 2 /Sub fertilization on soil carbon'


What is a codgers queries called?

A codger's queries would simply be called codger's queries.


What does IR Co mean when on a 30 caliber M1 carbine?

Name of maker or sub contractor


Are lexconsultants.com a good site for law related queries?

I would recommend Johnson Law Group Service and Boschen Law Firm. Check related link for web address.