📝 Question
#1074
The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
✓
Correct Answer
B. Lateral
💡
Explanation
Eg : 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);
⌨️ Press
A
B
C
D
to select