SELECT* , SUM(num) as '总数'FROMtd_textWHERENAME IN ( SELECT NAME FROM td_text GROUP BY NAME HAVING count(NAME) > 1 )GROUP BY `name`td_text 表数据: 执行sql后
select * from 用户表 where 用户名 in (select 用户名 from 用户表 group by 用户名 having count(1)>1)
selectt1.id,t1.from_uid,t2.name as from_name,t1.to_uid,t3.name as to_name,t1.contentfromchat t1,user t2,user t3where 1=1and t1.from_uid = t2.idand t1.to_uid = t3.idand t2.name in ('张三', '李四')and t3.name in ('张三', '李四')...
两种方法，一种是查询重复的数据，只查询重复记录，不管其余信息，如ID什么的： select uid, time from ztest GROUP BY uid, time having count(*)>1;查出结果是 uid time 1 1 还有一种是查询你指定信息，可以查询出ID信息： select distinct a....
上面的回答可以，不过我觉得还有更简单的方法： select aid, count(distinct uid) from 表名 group by aid 这是sqlserver 的写法。。。
可用group by……having来实现。 可做如下测试： 1、创建表插入数据： create table test(id int,name varchar(10))insert into test values (1,'张三')insert into test values (2,'李四')insert into test values (3,'张三')insert into test va...
1: SELECT * FROM `table` WHERE a=4 union ALL SELECT * FROM `table` WHERE b=4 union ALL SELECT * FROM `table` WHERE a=4 AND b=4
看一下这个SQL selectsum(if((sex = 1 and age = 2),1,0)),sum(if((sex = 1 and age = 5),1,0)),sum(if((sex = 1 and age = 10),1,0))from a_test 这个SQL现在就是得出的这个结果
查看可用如下方法： 1、创建测试表，插入数据： create table product(id int,name varchar(10),totol int)insert into product values (1,'香蕉',100)insert into product values (2,'橘子',67)insert into product values (3,'葡萄',89)insert...
不知道你的a,b两表有没有关联，假定没有关联 select count(1)from (select idfrom a where id>5union allselect id from b where id>5)