关于Sqlite查找重复记录的问题
数据库表中的列值只有三个
分别是时间,执行条件,操作。
现在是如何寻找重复记录次数最多的执行条件,只返回唯一的一列值
CREATE TABLE [Type] (
[TypeId] INT,
[TypeName] TEXT);
select n, i from (select Typename as n,TypeId as i from Type order by TypeName asc , TypeId asc) group by n;
热门标签:
数据库表中的列值只有三个
分别是时间,执行条件,操作。
现在是如何寻找重复记录次数最多的执行条件,只返回唯一的一列值
CREATE TABLE [Type] (
[TypeId] INT,
[TypeName] TEXT);
select n, i from (select Typename as n,TypeId as i from Type order by TypeName asc , TypeId asc) group by n;