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 dml statement?

511

---

what is rollback? : Sql dba

584

---

Does varchar need length?

514

---

how to use in conditions? : Sql dba

504

---

Can we use pl sql in mysql?

509

---

---

Can you sum a count in sql?

549

---

What are tables and fields?

578

---

What is the command used to fetch first 5 characters of the string?

876

---

Does mysql support pl sql?

615

---

What is pivot table in sql?

518

---

What is sql injection owasp?

540

---

what are properties of a transaction? : Sql dba

553

---

how do you login to mysql using unix shell? : Sql dba

558

---

what is unique key constraint? : Sql dba

561

---

What is sql engine in oracle?

513

---