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)

who introduced sql?

1012

---

Can you join views in sql?

951

---

What does inner join mean?

1157

---

How to get help at the sql prompt?

1111

---

How can we optimize a sql query?

1045

---

What does <> sql mean?

1079

---

What does count (*) do in sql?

1005

---

Is sql free?

955

---

What is the difference between instead of trigger and after trigger?

1006

---

Explain commit, rollback and savepoint.

993

---

Is left join inner or outer?

1013

---

Why are aggregate functions called so?

945

---

What is the max nvarchar size?

962

---

What is function and procedure?

1025

---

What is procedure in pl sql?

1040

---