mysql版本5.6.16,已提前排除所有null值
1 正常运行sql
-- sql1
select distinct waybill_no
from test1 p1
where p1.waybill_no in
(
select
* --利用mysql特性,求出时间最近的一条运单
from (
select
*
from test2
where create_time>'2000-01-01'
o