1、查找表中的一个字段,重复的只找一个:
SELECT DISTINCT COL1 FROM MYTEST;
2、查找表中的多个字段,其中某个字段不重复:
SELECT * FROM MYTEST WHERE rowid IN (SELECT min(rowid) FROM MYTEST GROUP BY COL1);
3、查询并统计该字段的数量。
SELECT COL1,COUNT(COL1) FROM MYTEST GROUP BY COL1;
1、查找表中的一个字段,重复的只找一个:
SELECT DISTINCT COL1 FROM MYTEST;
2、查找表中的多个字段,其中某个字段不重复:
SELECT * FROM MYTEST WHERE rowid IN (SELECT min(rowid) FROM MYTEST GROUP BY COL1);
3、查询并统计该字段的数量。
SELECT COL1,COUNT(COL1) FROM MYTEST GROUP BY COL1;