请问SQLITE怎么删除表内重复的记录

sqlite> select * from Yookey;
sid|tit
10001|hello1
10002|hello2
10002|hello3
10003|hello4
sqlite>
sqlite> delete from Yookey where tit not in (select min(tit) from Yookey group b
y SID);
sqlite> select * from Yookey;
sid|tit
10001|hello1
10002|hello2
10003|hello4
sqlite>