Re: Re: Question about OVER clause

2018-09-27 Thread anci_...@yahoo.com
'-MM-dd') Thanks! anci_...@yahoo.com From: Alan Gates Date: 2018-09-22 07:19 To: user; anci_sun Subject: Re: Question about OVER clause This article might be helpful. It's for SQL Server, but the semantics should be similar. https://www.sqlpassion.at/archive/2015/0

Re: Question about OVER clause

2018-09-21 Thread Alan Gates
This article might be helpful. It's for SQL Server, but the semantics should be similar. https://www.sqlpassion.at/archive/2015/01/22/sql-server-windowing-functions-rows-vs-range/ Alan. On Wed, Sep 19, 2018 at 6:47 AM 孙志禹 wrote: > Dears, >What is the difference between *ROW BETWEEN* and *