<div class="WordSection1"><p class="MsoNormal">Hi SQL experts,<p class="MsoNormal"> <p class="MsoNormal">I’ve got a
questionhere, is that possible to implement a window function without aggregation? Any SQL could get below desired
result?<pclass="MsoNormal"> <p class="MsoNormal">For example:<p class="MsoNormal"> <p class="MsoNormal">Table input<p
class="MsoNormal"> date | id<p class="MsoNormal">------------+--------<p class="MsoNormal">2014-04-26 | A<p
class="MsoNormal">2014-05-03| B<p class="MsoNormal">2014-05-10 | C<p class="MsoNormal">2014-05-17 | D<p
class="MsoNormal">2014-05-24| E<p class="MsoNormal">2014-05-31 | F<p class="MsoNormal"> <p class="MsoNormal">Expected
output,use 2 week roll up as an example:<p class="MsoNormal"> date | id<p
class="MsoNormal">------------+--------<pclass="MsoNormal">2014-04-26 | A<p class="MsoNormal">2014-05-03 | A<p
class="MsoNormal">2014-05-03| B<p class="MsoNormal">2014-05-10 | B<p class="MsoNormal">2014-05-10 | C<p
class="MsoNormal">2014-05-17| C<p class="MsoNormal">2014-05-17 | D<p class="MsoNormal">2014-05-24 | D<p
class="MsoNormal">2014-05-24| E<p class="MsoNormal">2014-05-31 | E<p class="MsoNormal">2014-05-31 | F<p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Thanks,<p
class="MsoNormal">Suya</div>