adspace


what is the difference between the query and corelated
query

Answer Posted / saurabh

When 1st main query is executed then the result of the main
query is used in teh where clause of subquery then this
type of subquery is called as co-related sub query.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key always clustered index?

1094


What is the current version of postgresql?

1177


Do we need to rebuild index after truncate?

1137


how many tables will create when we create table, what are they? : Sql dba

1144


how to escape special characters in sql statements? : Sql dba

1113


what are aggregate and scalar functions? : Sql dba

1127


what is collation? : Sql dba

1229


Can delete statement be rollbacked?

1053


What is your daily office routine?

2345


what are the advantages of sql ? : Sql dba

1141


what is schema? : Sql dba

1146


What is the best sql course?

1050


Can we use distinct and group by together?

1133


Does group by remove duplicates?

1112


What is the current version of sql?

1092