利用表的ROWID select rowid,c1,c2 from lunar where lunar.rowid!=(select max(rowid) from lunar b where lunar.c1=b.c1 and lunar.c2=b.c2)and date between 'A' and 'Y'; 记得结贴的话要说一声
select cname from tablename where cname between 'a' and 'y' group by cname having count(cname)>1 我是这样写的 ...
select rowid,c1,c2 from lunar where lunar.rowid!=(select max(rowid) from lunar b where lunar.c1=b.c1 and lunar.c2=b.c2)and date between 'A' and 'Y';
记得结贴的话要说一声