Answer Posted / aravinda

query: query is single time validation of conditions for
entire result once result is fetched there no further
validation of records.

corelated sub query : each record is validated with inner
query aftr fetch.

1) outer query will execute first and pass a value to inner
query.
2) based on outer query value inner query will execute.
3) based on inner query value the outer query record will be
validated.

inner query will execute for every record of outer query( if
outer query has 10 records inner query will execute 10 times)

What is varchar sql?

1146

---

What is the example of procedure?

928

---

What is rank () in sql?

942

---

What are tables in sql?

1066

---

Why should I use postgresql?

1018

---

Explain the difference in execution of triggers and stored procedures?

1022

---

What is the cause of mutating table error and how can we solve it?

1049

---

Is delete faster than truncate?

1002

---

What's the difference between inner join and left join?

1000

---

what is a cursor? : Sql dba

1025

---

What does (*) mean in sql?

953

---

How do you concatenate in sql?

1028

---

tell me about various levels of constraint. : Sql dba

1035

---

Is it possible to pass parameters to triggers?

1103

---

Is sql harder than python?

1108

---