Demo entry 6312575

aaaaaaaaaaa

   

Submitted by anonymous on Oct 25, 2016 at 09:04
Language: ABNF. Code size: 673 Bytes.

select *
  from QS_LGY_2011
 where ZKLSH in (SELECT A.Zklsh
                   FROM QS_LGY_2011 A, QS_LGY_2011 B
                  where A.ZJHM <> '@'
                    AND A.ZSLG = B.ZSLG
                    AND A.FH = B.FH
                    AND A.RZSJ BETWEEN
                        TO_CHAR(TO_DATE(B.RZSJ, 'YYYY-MM-DD HH24:mi:ss') -
                                10 / 60 / 24,
                                'YYYYMMDDHH24MISS') AND
                        TO_CHAR(TO_DATE(B.RZSJ, 'YYYY-MM-DD HH24:mi:ss') -
                                (-10) / 60 / 24,
                                'YYYYMMDDHH24MISS')
                    AND B.ZJHM = '@');

This snippet took 0.01 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).