求一日期匹配的ORACEL sql。在线等！！！

Question

ZT KSSJ JSSJ MBID
ZF 2015-12-11 2016-12-11 1
ZF 2015-12-18 2016-12-18 1
ZF 2015-12-18 2016-12-18 1
ZF 2015-12-19 2016-12-19 1
TF 2016-01-14 1
ZF 2016-02-19 2017-02-19 1
ZF 2016-02-29 2016-04-30 1
TF 2016-03-21 1
ZF 2015-12-11 2016-12-11 3
ZF 2015-12-18 2016-12-18 3
ZF 2015-12-18 2016-12-18 3
ZF 2015-12-19 2016-12-19 3
TF 2016-01-14 3
ZF 2016-02-19 2017-02-19 3
ZF 2016-02-19 2017-02-19 3
ZF 2016-01-14 2016-03-14 4
ZF 2016-02-04 2017-02-04 4
ZF 2016-02-19 2017-02-19 4
TF 2016-02-29 4
ZF 2016-02-19 2017-02-19 61

上面为原始数据。最终想要的结果为：
KSSJ JSSJ MBID
2015-12-11 2016-01-14 1
2016-02-19 2016-03-21 1
2015-12-11 2016-01-14 3
2016-02-19 2017-02-19 3
2015-01-14 2016-02-29 4
2016-02-19 2017-02-19 61

Answer 1

http://www.cnblogs.com/hl3292/archive/2010/11/03/1868159.html