delete from a where (FDID = (SELECT FDID,FDDATE,FDTIME FROM (TableName t1) WHERE FDTIME = (SELECT max(FDTIME) FROM (TableName t2) WHERE t1.ID = t2.ID AND t1.FDDATE =t2.FDDATE))) and (FDDATE =(SELECT ID,FDDATE,FDTIME FROM (TableName t1) WHERE FDTIME = (SELECT max(FDTIME) FROM (TableName t2) WHERE t1.ID = t2.ID AND t1.FDDATE =t2.FDDATE))) 这是使用一条语句完成的,也可以使用多条语句(对上面的进行拆分)
delete from tableA where fdid=(select tableA.fdid from tableA,tableB where tableA.fdid=tableB.fdid and tableA.fddate=tableB.fddate)
FDTIME = (SELECT max(FDTIME) FROM (TableName t2) WHERE t1.ID = t2.ID AND t1.FDDATE =t2.FDDATE)
FDTIME = (SELECT max(FDTIME) FROM (TableName t2) WHERE t1.ID = t2.ID AND t1.FDDATE =t2.FDDATE))) and (FDDATE =(SELECT ID,FDDATE,FDTIME FROM (TableName t1) WHERE
FDTIME = (SELECT max(FDTIME) FROM (TableName t2) WHERE t1.ID = t2.ID AND t1.FDDATE =t2.FDDATE))) 这是使用一条语句完成的,也可以使用多条语句(对上面的进行拆分)