0

Would like to know what is LATERAL and why LATERAL in SQL? Have few question to understand more on LATERAL. I searched in google and not getting clear understanding of LATERAL.

  1. Why Lateral
  2. Advantage of Lateral
  3. Lateral View Vs Lateral Join.
  4. What scenario we need to use Lateral View and Lateral join.

Please share your thought on this.

Learn Hadoop
  • 2,760
  • 8
  • 28
  • 60
  • 1
    That is what the docs are for. Go here [Select](https://www.postgresql.org/docs/current/sql-select.html) and search on LATERAL. – Adrian Klaver Apr 02 '23 at 04:16
  • The term lateral-join is wrong. It's not the join which is lateral, it's the subquery after the LATERAL keyword. – jarlh Apr 18 '23 at 06:15

0 Answers0