What is the purpose of the WINDOW clause in SQL (available in PostgreSQL and others)?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What is the purpose of the WINDOW clause in SQL (available in PostgreSQL and others)?

Key points

  • The WINDOW clause is used to create a reusable window specification.
  • It enhances query readability by eliminating repetition.
  • This feature is particularly useful when working with complex analytical queries.

Ready to go further?

Start full exam Practice more questions

Related questions