Pergunta de entrevista da empresa ChenMed
Correlated SQL queries, when would you use it and why? What executes first, inner or outer ?
Resposta da entrevista
Sigiloso
1 de ago. de 2022
outer query is executed first. It is slow but you could use it for row by row comparison and it is similar to recursion, for example find the second highest paid doctor.
1