说明:从A表查询FORMID不为重复的记录(FORMID不为空),且符合条件1。ID为primarykey。
select * from A where ID in (select max(ID) from A where 条件1=1 GROUP BY FORMID) order by ID desc
说明:从A表查询FORMID不为重复的记录(FORMID不为空),且符合条件1。ID为primarykey。
select * from A where ID in (select max(ID) from A where 条件1=1 GROUP BY FORMID) order by ID desc