SQL开窗函数学习（一）

开窗函数模式：
分析函数（sum()…） over( [partition by xxx] order by xxx [desc] [ROWS BETWEEN xxx and xxx]) as xxx
eg: SUM(price) OVER(partition by p_desc order by price)

CREATE TABLE "TEST4" 
   (	"ID" VARCHAR2(100), 
	"P_DESC" VARCHAR2(100)