select location.province as provin,max(situation.reporttime) as report from situation, location, mbugzone where situation.locationid=location.locationid and situation.locationid=mbugzone.locationid
group by location.province order by report
group by location.province order by report
select max(situation.reporttime) as report from situation,location,mbugzone where situation.locationid=location.locationid and situation.locationid=mbugzone.locationid如果要取每个location.province 的最大值:
select location.province as provin,max(situation.reporttime) as report from situation,location,mbugzone where situation.locationid=location.locationid and situation.locationid=mbugzone.locationid
group by location.province as provin
select delivery.deliveryid as deliver,situation.currentstatus as situa,location.province as provin,mbugzone.zonename as zone,situation.reporttime as report from situation,delivery,location,mbugzone where delivery.username='anda' and delivery.tripid = situation.tripid and situation.locationid=location.locationid and situation.zoneid=mbugzone.zoneid and situation.locationid=mbugzone.locationid order by report
现在是要附加取一个situation.reporttime 的最大值,按照上面两位说的现在是不行的。