试图分析彩票数字
因此，导入带有获胜彩票数量到彩票表我想知道多久一次数字是绘制的。
我只使用这样的数字来完成它
select count(id), n1
from lotto
group by n1
having count(id) > 100
order by count(id) desc
立即将其用于所有数字（尝试过怪异的自我加入）
select lt1.count(id) as c1,
lt1.n2 as number2,
lt2.count(id) as c2,
lt2.n3 as number3
from lotto lt1, lotto lt2
where lt1.count(id) <> lt2.count(id)
group by number2, number3
而没有成功:(
有什么想法吗？
So import csv file with numbers of winning lottery to lottery table and i want to know how often each number is draw.
i made it only for 1 number using something like this
select count(id), n1
from lotto
group by n1
having count(id) > 100
order by count(id) desc
and cant figure it out to make it for all numbers at once(tried weird self join)
select lt1.count(id) as c1,
lt1.n2 as number2,
lt2.count(id) as c2,
lt2.n3 as number3
from lotto lt1, lotto lt2
where lt1.count(id) <> lt2.count(id)
group by number2, number3
without success :(
any idea?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论