About

This site was built after doing the exercises in PG Exercises It was made by Narendra Mandadapu

• Why did you create this?
• What technologies did you use?
• How can I learn about SQL window functions?
• Does my database support this?

Why did you create this?

While there are several websites similar to PG Exercises that allow you to interact with SQL interactivly none of them focus on the post sql-92 window functions. Most databases got these awesome powerful functions a long time ago and most of us don't use them

What technologies did you use?

Rust & Postgres.

How can I learn about SQL window functions?

Links to learn about window functions:

• Postgres
• Mode Analytics
• Use The Index Luke
• Understanding window functions

Links to learn more about Postgres

• Introduction to Postgres
• PG Exercises

Does my database support window functions?

Probably, the only major one that doesn't is MySQL (which is superseded by Maria DB which does).

Try it and see!