22,209
社区成员
发帖
与我相关
我的任务
分享
select a.*,b.cnt
from tb a
left join
(select number,count(1) as cnt from tb group by number) b
on a.number=b.number
SELECT *
,
(SELECT COUNT(NUMBER) FROM TB WHERE NUMBER=T.NUMBER GROUP BY NUMBER) AS NUM
FROM TB T
那你日期是怎么算?
SELECT *
,
(SELEC COUNT(NUMBER) FROM TB WHERE NUMBER=T.NUMBER GROUP BY NUMBER) AS NUM
FROM TB T
select a.*,cnt
from tb a,
inner join
(select num,count(*) cnt from tb group by num) b
on a.num = b.num