René's URL Explorer Experiment

{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt","url":"https://sqlint.com","logo":"https://sqlint.com/og-image.jpg","email":"support.sqlint@gmail.com","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","disambiguatingDescription":"SqlInt (sqlint.com) is a browser-based SQL practice and interview-preparation website with free client-side SQL tools - a web platform, not a command-line utility.","contactPoint":{"@type":"ContactPoint","contactType":"customer support","email":"support.sqlint@gmail.com","availableLanguage":["en"]},"subjectOf":[{"@type":"WebPage","url":"https://sqlint.com/about","name":"About SqlInt"}],"sameAs":[]},{"@type":"WebSite","@id":"https://sqlint.com/#website","url":"https://sqlint.com","name":"SqlInt","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","publisher":{"@id":"https://sqlint.com/#organization"}}]}

{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://sqlint.com"},{"@type":"ListItem","position":2,"name":"Learn SQL","item":"https://sqlint.com/learn-sql"},{"@type":"ListItem","position":3,"name":"Window Functions","item":"https://sqlint.com/learn-sql/window-functions"}]}

{"@context":"https://schema.org","@type":"FAQPage","mainEntity":[{"@type":"Question","name":"When do I still need GROUP BY instead of a window?","acceptedAnswer":{"@type":"Answer","text":"When the output should be one row per group — counts, totals, averages for a report. Windows keep detail rows; GROUP BY collapses them. If you catch yourself GROUP BY-ing and then re-joining detail rows, you wanted a window."}},{"@type":"Question","name":"Do window functions hurt performance?","acceptedAnswer":{"@type":"Answer","text":"They need their input sorted by PARTITION BY + ORDER BY, which is real cost on large tables — but it is one sort versus a GROUP BY plus a self-join, which is usually worse. An index matching the window's ordering can eliminate the sort (Topic 21). EXPLAIN and compare (Topic 22)."}}]}

{"@context":"https://schema.org","@type":"LearningResource","@id":"https://sqlint.com/learn-sql/window-functions#learning-resource","name":"Window Functions — SQL Tutorial with Examples","description":"Learn SQL Window Functions. Includes syntax, examples, mistakes, and interview tips.","speakable":{"@type":"SpeakableSpecification","cssSelector":["h1",".topic-explanation"]},"citation":["https://www.postgresql.org/docs/current/sql.html","https://sqlite.org/lang.html","https://www.postgresql.org/docs/current/tutorial.html"],"isPartOf":{"@id":"https://sqlint.com/learn-sql#course"},"educationalLevel":"Advanced","teaches":["Syntax: FUNCTION() OVER (\n  PARTITION BY col\n  ORDER BY col\n  ROWS BETWEEN ... AND ...\n)","Core concept: Window functions perform calculations across rows related to the current row WITHOUT collapsing them","Common mistakes: Confusing RANK and DENSE_RANK: RANK gives 1,2,2,4 (skips 3). DENSE_RANK gives 1,2,2,3 (no skip). ROW","Interview tips: Window functions are the #1 topic at FAANG-level SQL interviews. Know ROW_NUMBER for deduplication ("],"timeRequired":"25 mins","about":{"@type":"Thing","name":"SQL","description":"Structured Query Language"},"audience":{"@type":"EducationalAudience","educationalRole":"student"},"author":{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt"},"url":"https://sqlint.com/learn-sql/window-functions"}