查询重复数据,用语句:
select
id,
name
from
test
group
by
id,
name
having
count
(*)>1;
删除重复记录用语句:
delete
from
test
where
rowid
not
in
(
select
min
(rowid)
from
test
group
by
id,
name
);
commit
;
select * from 表 where 语文分数>(select avg(语文分数) from 表)