Pastable version of Can I do it without accessing 2x the same table?

<pre class='prettyprint' language='php'>select rrr.account_number,
       summa,
       to_char(to_date('19570101', 'YYYYMMDD') + max(rrr.lst_pay_dn),
               'YYYYMMDD')
  from (select account_number, sum(xamount) summa
          from (select account_number, r.xamount
                  from rdcho r
                 where trncde = 6722
                   and xstatus &lt;&gt; 'S'
                   and ((r.ledger_dn &gt; 18992 and r.ledger_dn &lt; 19024 and
                       r.lst_pay_dn &lt; 19024 and r.out_amt = 0) or
                       (r.lst_pay_dn &gt; 18992 and r.lst_pay_dn &lt; 19024 and
                       r.out_amt = 0 and r.ledger_dn &lt; 18993))
                   and account_number in
                       ('180005753763', '192002567023', '192002898856',
                        '192003121600 ')
                 order by account_number, ledger_dn)
         group by account_number) rr,
       rdcho rrr
where rrr.account_number = rr.account_number
   and rrr.lst_pay_dn &gt; 18992
   and rrr.lst_pay_dn &lt; 19024
   and xstatus &lt;&gt; 'S'
   and trncde = 6722
group by rrr.account_number, summa</pre>
<a href="http://www.refactormycode.com/codes/773-can-i-do-it-without-accessing-2x-the-same-table" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of Can I do it without accessing 2x the same table?