adspace


what is the difference between the query and corelated
query

Answer Posted / guruswamy

corelated query is refered by each an every value by
subquery.
normal query is referd by subquery one bulk amount to get a
main query

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to start mysql server? : Sql dba

1267


What is your daily office routine?

2346


what is collation? : Sql dba

1229


If a cursor is open, how can we find in a pl/sql block?

1238


what are aggregate and scalar functions? : Sql dba

1129


Can we use distinct and group by together?

1133


what is dbms? : Sql dba

1061


How do I remove duplicates in two columns?

1186


Do we need to rebuild index after truncate?

1138


Is inner join faster than left join?

1276


Is primary key always clustered index?

1095


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

1114


Can we rollback truncate?

1074


What is the current version of postgresql?

1178


what is schema? : Sql dba

1147