SELECT TermName,Phone,Lon,Lat,GPSTime
FROM SOSAlarmWHERE exists(
select * from(
select SOSAlarm.TermName,MAX(ID) as ID from SOSAlarm group by SOSAlarm.TermName) x
WHERE SOSAlarm.TermName=x.TermName AND SOSAlarm.ID=x.ID)
SQL 查询表格中某字段不同值的最新一条记录
WHERE exists(
select * from(
select SOSAlarm.TermName,MAX(ID) as ID from SOSAlarm group by SOSAlarm.TermName) x
WHERE SOSAlarm.TermName=x.TermName AND SOSAlarm.ID=x.ID)