表结构
id name
1 aa
2 aa
3 bb
求 如何 求数量 有多少个名字 出现了两次的语句,谢谢。
sql 语句解惑select name from XX group by name having count(name)
答案:2 悬赏:40
解决时间 2021-02-21 22:51
- 提问者网友:紫柔同归
- 2021-02-21 08:07
最佳答案
- 二级知识专家网友:茫然不知崩溃
- 2021-02-21 08:15
我测试的,看看是不是你要的吧。
CREATE TABLE T1
(
ID INT,
NAME VARCHAr(45)
)
INSERT INTO T1 VALUES(1,'AA')
INSERT INTO T1 VALUES(2,'CC')
INSERT INTO T1 VALUES(3,'DD')
INSERT INTO T1 VALUES(4,'BB')
INSERT INTO T1 VALUES(5,'AA')
INSERT INTO T1 VALUES(6,'CC')
INSERT INTO T1 VALUES(7,'AA')
INSERT INTO T1 VALUES(8,'BB')
INSERT INTO T1 VALUES(9,'EE')
INSERT INTO T1 VALUES(10,'EE')
INSERT INTO T1 VALUES(11,'WW')
create view MyView
as
SELECt NAME FROM T1 group by name HAVINg COUNT(NAME)=2
select COUNT(*) from MyView结果为:3
CREATE TABLE T1
(
ID INT,
NAME VARCHAr(45)
)
INSERT INTO T1 VALUES(1,'AA')
INSERT INTO T1 VALUES(2,'CC')
INSERT INTO T1 VALUES(3,'DD')
INSERT INTO T1 VALUES(4,'BB')
INSERT INTO T1 VALUES(5,'AA')
INSERT INTO T1 VALUES(6,'CC')
INSERT INTO T1 VALUES(7,'AA')
INSERT INTO T1 VALUES(8,'BB')
INSERT INTO T1 VALUES(9,'EE')
INSERT INTO T1 VALUES(10,'EE')
INSERT INTO T1 VALUES(11,'WW')
create view MyView
as
SELECt NAME FROM T1 group by name HAVINg COUNT(NAME)=2
select COUNT(*) from MyView结果为:3
全部回答
- 1楼网友:温柔刺客
- 2021-02-21 08:57
select name,sum(1) from XX group by name
再看看别人怎么说的。
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯