摘要:
HAVING COUNT(字段)统计表中某一字段出现的次数 SELECT 字段 FROM 表 GROUP BY 字段 HAVING COUNT(字段) > 1 SELECT * FROM 表 WHERE 字段 IN(SELECT 字段 FROM 表 GROUP BY 字段 HAVING COUNT( 阅读全文
摘要:
#coding:utf-8 tuple_a = (1,2,3,4,3,2,1)#找出不重复的数,并打印出来 for i in range(len(tuple_a)):#按长度遍历列表 if tuple_a.count(tuple_a[i])==1:#查找tuple中出现一次的数 print(tupl 阅读全文