110,549
社区成员
发帖
与我相关
我的任务
分享
Stream fileStream = File.OpenRead(file);
Workbook book = new Workbook();
book.Open(fileStream);
Worksheet sheet = book.Worksheets[0];
int row = 1;
int col = 0;
string ID = sheet.Cells[row, col].StringValue;
Picture pic = sheet.ExtractPicture(row, col);
select id,name,count(*)
from data2 group by id,name
having count(*) > 1 //根据id和name判断重复
删除重复项,只保留最新的
create table data2 as
select a.id,a.name,MAX(a.ROWID) dataid
from data3 a GROUP BY a.id,a.name;
delete from data3 a
where a.rowid !=
(
select b.dataid from data2 b
where a.id = b.id and
a.name = b.name
);
commit;