select minup.ip,minup.pro,minup.tup,maxup.tup,maxup.tup-minup.tup from
(select ip,pro,tup from audit_flow f1
where `date`=(
select max(`date`) from audit_flow where ip=f1.ip and pro=f1.pro)) as maxup
inner join (
select ip,pro,tup from audit_flow f1 where `date`=(
select min(`date`) from audit_flow where ip=f1.ip and pro=f1.pro)) as minup on minup.ip=maxup.ip and minup.pro=maxup.pro;
数了一下,一共有6个Select语句,SQL原来都是把简单问题复杂化