The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
A. In
B. Lateral
C. Having
D. With
Answer:A
The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
A. In B. Lateral C. Having D. With
Explanation:Select name, salary, avg salary from instructor I1, lateral (select avg(salary) as avg salary from instructor I2 where I2.dept name= I1.dept name);