by 지현명 [PostgreSQL 노하우/팁/자료] [2016.10.24 16:07:51]
https://www.postgresql.org/docs/9.6/static/sql-expressions.html
4.2.8 윈도우 함수의 Window frame clause
테스트 db설치 : https://github.com/sramazzina/AWPostgreSQL
비교표는 첨부파일 열어 주세요~
테스트 서버
PostgreSQL 9.6.0, compiled by Visual C++ build 1800, 64-bit
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)