tianlong1569的专栏

lead(列名,1)over(orderby列名)用结果集中第一列和第二列进行比对，显示大的值lag(列名,1)over(orderby列名)用结果集中第一列和第二列的数据进行比对，显示比较小的数据；如：SELECTt.*,lead(updatedate,1)over(orderbyupdatedate)FROMoffice_workflo...

select level,DEPARTMENT_GUID,SUPERIOR_GUID,DEPARTMENT_NAME from risenet_department start with superior_guid='{0A130410-0000-0000-2E32-7B6700000001}'CONNECT BY PRIOR department_GUID=SUPERIOR_GUIDo...

1. SQL（Structured Query Language）SQL有许多关键字，以下语句是常用于开头的语句：Alter                       Insert Audit                       Lock Commit                      NoauditComment                     Re