Answer Posted / bis

A query which uses values from the outer query is called as a correlated sub query. The subquery is executed once and uses the results for all the evaluations in the outer query.

Here, the sub query references the employee_id in outer query. The value of the employee_id changes by row of the outer query, so the database must rerun the subquery for each row comparison. The outer query knows nothing about the inner query except its results.

select employee_id, appraisal_id, appraisal_amount From employee
where
appraisal_amount < (select max(appraisal_amount)
from employee e
where employee_id = e. employee_id);

Is it possible for a table to have more than one foreign key?

1076

---

what are null values? : Sql dba

1010

---

Can we create table in function?

1017

---

What are the parameter modes supported by pl/sql?

1147

---

how to create a test table in your mysql server? : Sql dba

1052

---

What are all ddl commands?

1125

---

what are the advantages of sql ? : Sql dba

1105

---

What are the two types of cursors in pl sql?

1121

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1129

---

Can we write dml inside a function in sql server?

1002

---

What is user defined functions?

1028

---

Can you call pl/sql package functions from within a fast formula?

1080

---

How to handle bulk data?

1362

---

what is a cursor? : Sql dba

1062

---

What is sql and explain its components?

1113

---