双色球缩水的sql语句

最新推荐文章于 2022-06-27 18:16:08 发布
最新推荐文章于 2022-06-27 18:16:08 发布
阅读量761 收藏 1
点赞数
分类专栏： 杂记 文章标签： sql table insert object 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hrb2008/article/details/3942056
版权

无聊的时候写的，参考阿良的一篇22选5的

 

-- 从网站下载七位号码存为aa.txt 以tab分隔字段，导入到sql2000中字段为col001, ..col007.
-- 导入文本文件到数据库中，表名为aa
alter table aa
add
acvalue int, -- ac值
jsgs int,    -- 奇数个数
osgs int,    -- 偶数个数
top6 int,    -- 本期号码出现在前六期中的个数
twtz int,    -- 本期号码与上期号码同位同值
lh int,      -- 连号
sumvalue int,-- 和值
kdvalue int, -- 跨度值 第六位与第一位的差值
b11 int,     -- col1-col6出现在01-11区间的个数
b22 int,     -- col1-col6出现在12-22区间的个数
b33 int      -- col1-col6出现在23-33区间的个数

 

-- 构建辅助表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T1]'))
drop table [dbo].[T1]
GO
create table T1(R1 varchar(10))
Go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T2]'))
drop table [dbo].[T2]
GO
create table T2(R2 varchar(10))
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T3]'))
drop table [dbo].[T3]
GO
create table T3(R3 varchar(10))
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T4]'))
drop table [dbo].[T4]
GO
create table T4(R4 varchar(10))
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T5]'))
drop table [dbo].[T5]
GO
create table T5(R5 varchar(10))
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[T6]'))
drop table [dbo].[T6]
GO
create table T6(R6 varchar(10))
GO
/*** 组合数据 置入辅助数据 ***/
--R1
declare @i int
set @i=1
A:
begin
    insert into T1 select right('0'+Cast(@i as varchar(10)),2)
end
set @i=@i+1
if @i <=28 goto A
select * from T1
GO

--R2
declare @i int
set @i=2
A:
begin
    insert into T2 select right('0'+Cast(@i as varchar(10)),2)
end
set @i=@i+1
if @i <=29 goto A
select * from T2
GO

--R3
declare @i int
set @i=3
A:
begin
    insert into T3 select right('0'+Cast(@i as varchar(10)),2)
end
set @i=@i+1
if @i <=30 goto A
select * from T3
GO

--R4
declare @i int
set @i=4
A:
begin
    insert into T4 select right('0'+Cast(@i as varchar(10)),2)
end
set @i=@i+1
if @i <=31 goto A
select * from T4
GO

--R5
declare @i int
set @i=5
A:
begin
    insert into T5 select right('0'+Cast(@i as varchar(10)),2)
end
set @i=@i+1
if @i <=32 goto A
select * from T5
GO

--R6
declare @i int
set @i=6
A:
begin
    insert into T6 select right('0'+Cast(@i as varchar(10)),2)
end
set @i=@i+1
if @i <=33 goto A
select * from T6
GO
/************************************/
select * into T from T1,T2,T3,T4,T5,T6
where
R1<R2 and R1<R3 and R1<R4 and R1<R5 and R1<R6 and
R2<R3 and R2<R4 and R2<R5 and R2<R6 and
R3<R4 and R3<R5 and R3<R6 and
R4<R5 and R4<R6 and
R5<R6

 

select identity(int,1,1) as id,* into #tt from
(
/*
select
'01' as Col001,
'02' as Col002,
'03' as Col003,
'04' as Col004,
'05' as Col005,
'06' as Col006
union all
*/
select
Col001,Col002,Col003,Col004,Col005,Col006
from aa
) as newaa

-- 计算AC列
ALTER TABLE #tt ADD acvalue INT
GO
update #tt set  acvalue =
(select count(*) from
(
select right('0'+Cast(Cast(Col006 as int)-Cast(Col005 as int) as varchar(10)),2) as a union
select right('0'+Cast(Cast(Col006 as int)-Cast(Col004 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col006 as int)-Cast(Col003 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col006 as int)-Cast(Col002 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col006 as int)-Cast(Col001 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col005 as int)-Cast(Col004 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col005 as int)-Cast(Col003 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col005 as int)-Cast(Col002 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col005 as int)-Cast(Col001 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col004 as int)-Cast(Col003 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col004 as int)-Cast(Col002 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col004 as int)-Cast(Col001 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col003 as int)-Cast(Col002 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col003 as int)-Cast(Col001 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(Col002 as int)-Cast(Col001 as int) as varchar(10)),2)
)  AS T)-5

-- 计算AC列结束

-- 计算连号个数
ALTER TABLE #tt ADD lh INT
GO
UPDATE #tt SET lh =
CASE WHEN cast (col002 as int) - cast (col001 as int)=1 THEN 1 ELSE 0 END +
CASE WHEN cast (col003 as int) - cast (col002 as int)=1 THEN 1 ELSE 0 END +
CASE WHEN cast (col004 as int) - cast (col003 as int)=1 THEN 1 ELSE 0 END +
CASE WHEN cast (col005 as int) - cast (col004 as int)=1 THEN 1 ELSE 0 END +
CASE WHEN cast (col006 as int) - cast (col005 as int)=1 THEN 1 ELSE 0 END
-- 计算连号个数 结束

-- 计算和值
ALTER TABLE #tt ADD sumvalue INT
GO
UPDATE #tt SET sumvalue =
cast(col001 as int) +
cast(col002 as int) +
cast(col003 as int) +
cast(col004 as int) +
cast(col005 as int) +
cast(col006 as int)
-- 计算连号个数 结束

-- 计算跨度值
ALTER TABLE #tt ADD kdvalue INT
GO
UPDATE #tt SET kdvalue =
cast(col006 as int) - cast(col001 as int)
-- 计算跨度值

-- 计算奇数个数
ALTER TABLE #tt ADD jsgs INT
GO
UPDATE #tt SET jsgs=Col001%2+Col002%2+Col003%2+Col004%2+Col005%2+Col006%2
-- 计算奇数个数结束

-- 计算偶数个数
ALTER TABLE #tt ADD osgs INT
GO
UPDATE #tt SET osgs=6-(Col001%2+Col002%2+Col003%2+Col004%2+Col005%2+Col006%2)
-- 计算偶数个数结束

-- 上六期出现的个数
ALTER TABLE #tt ADD top6 INT
GO
update #tt set top6 =
case when col001 in
(
select top 6 col001 from #tt as b where b.id>#tt.id union
select top 6 col002 from #tt as b where b.id>#tt.id union
select top 6 col003 from #tt as b where b.id>#tt.id union
select top 6 col004 from #tt as b where b.id>#tt.id union
select top 6 col005 from #tt as b where b.id>#tt.id union
select top 6 col006 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col002 in
(
select top 6 col001 from #tt as b where b.id>#tt.id union
select top 6 col002 from #tt as b where b.id>#tt.id union
select top 6 col003 from #tt as b where b.id>#tt.id union
select top 6 col004 from #tt as b where b.id>#tt.id union
select top 6 col005 from #tt as b where b.id>#tt.id union
select top 6 col006 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col003 in
(
select top 6 col001 from #tt as b where b.id>#tt.id union
select top 6 col002 from #tt as b where b.id>#tt.id union
select top 6 col003 from #tt as b where b.id>#tt.id union
select top 6 col004 from #tt as b where b.id>#tt.id union
select top 6 col005 from #tt as b where b.id>#tt.id union
select top 6 col006 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col004 in
(
select top 6 col001 from #tt as b where b.id>#tt.id union
select top 6 col002 from #tt as b where b.id>#tt.id union
select top 6 col003 from #tt as b where b.id>#tt.id union
select top 6 col004 from #tt as b where b.id>#tt.id union
select top 6 col005 from #tt as b where b.id>#tt.id union
select top 6 col006 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col005 in
(
select top 6 col001 from #tt as b where b.id>#tt.id union
select top 6 col002 from #tt as b where b.id>#tt.id union
select top 6 col003 from #tt as b where b.id>#tt.id union
select top 6 col004 from #tt as b where b.id>#tt.id union
select top 6 col005 from #tt as b where b.id>#tt.id union
select top 6 col006 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col006 in
(
select top 6 col001 from #tt as b where b.id>#tt.id union
select top 6 col002 from #tt as b where b.id>#tt.id union
select top 6 col003 from #tt as b where b.id>#tt.id union
select top 6 col004 from #tt as b where b.id>#tt.id union
select top 6 col005 from #tt as b where b.id>#tt.id union
select top 6 col006 from #tt as b where b.id>#tt.id
) then 1 else 0 end
-- 上六期出现的个数 结束

-- 上期同位出现同值
ALTER TABLE #tt ADD twtz INT
GO
update #tt set twtz =
case when col001 in
(
select top 1 col001 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col002 in
(
select top 1 col002 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col003 in
(
select top 1 col003 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col004 in
(
select top 1 col004 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col005 in
(
select top 1 col005 from #tt as b where b.id>#tt.id
) then 1 else 0 end +
case when col006 in
(
select top 1 col006 from #tt as b where b.id>#tt.id
) then 1 else 0 end

-- 上期同位出现同值 结束
-- 计算各区间分布
ALTER TABLE #tt ADD b11 INT,b22 INT,b33 INT
GO
update #tt set
b11 =
case when col001<=11 then 1 else 0 end +
case when col002<=11 then 1 else 0 end +
case when col003<=11 then 1 else 0 end +
case when col004<=11 then 1 else 0 end +
case when col005<=11 then 1 else 0 end +
case when col006<=11 then 1 else 0 end
,
b22 =
case when col001 >11 and col001<=22 then 1 else 0 end +
case when col002 >11 and col002<=22 then 1 else 0 end +
case when col003 >11 and col003<=22 then 1 else 0 end +
case when col004 >11 and col004<=22 then 1 else 0 end +
case when col005 >11 and col005<=22 then 1 else 0 end +
case when col006 >11 and col006<=22 then 1 else 0 end
,b33 =
case when col001 >22 and col001<=33 then 1 else 0 end +
case when col002 >22 and col002<=33 then 1 else 0 end +
case when col003 >22 and col003<=33 then 1 else 0 end +
case when col004 >22 and col004<=33 then 1 else 0 end +
case when col005 >22 and col005<=33 then 1 else 0 end +
case when col006 >22 and col006<=33 then 1 else 0 end
-- 计算各区间分布 结束

/*==================================================*/
-- 以下为ac值分析方法
select acvalue,count(1) as vccnt from #tt group by acvalue order by vccnt
-- 以下为连号分析方法
select lh,count(1) as lhcnt from #tt group by lh order by lhcnt
-- 以下为奇数个数分析方法
select jsgs ,count(1) as jscnt from #tt group by jsgs order by jscnt
-- 前六期出现分析
select top6 ,count(1) as tp6cnt from #tt group by top6 order by tp6cnt
-- 同位同值出现分析 [0-3 其中0:500 1:201 2:46 3:9 在此处可以只取01]
select twtz ,count(1) as twtzcnt from #tt group by twtz order by twtzcnt
-- 和值分析 42 - 158
select sumvalue,count(1) as sumcnt from #tt group by sumvalue order by sumcnt
-- 跨度值分析 9 - 32
select kdvalue,count(1) as kdcnt from #tt group by kdvalue order by kdcnt
-- 首位分析 1 - 19
select cast(col001 as int) as col1,count(1) as sumsw from #tt group by col001 order by sumsw
-- 末位分析 14 - 33
select cast(col006 as int) as col6,count(1) as summw from #tt group by col006 order by summw
-- 加入区间分析 分析在 1-11 12-22 23-33出现的情况

/*==================================================*/
truncate table aa
go
insert into aa(col001,col002 ,col003 ,col004 ,col005 ,col006 ,acvalue,jsgs,osgs,top6,twtz,lh,sumvalue,kdvalue)
SELECT col001,col002 ,col003 ,col004 ,col005 ,col006 ,acvalue,jsgs,osgs,top6,twtz,lh,sumvalue,kdvalue FROM #tt
-- 删除临时表
drop table  #tt


-- 缩水开始
select * from T where
--首号:[01-19]
R1>='01'
and R1<='19'
--尾号:[14-33]
and R6 >='14'
and R6 <='33'
--奇数:[0-6]
and (R1%2 + R2%2 + R3%2 + R4%2 + R5%2+ R6%2)>=0
and (R1%2 + R2%2 + R3%2 + R4%2 + R5%2+ R6%2)<=6
--和值:[42-158]
and (Cast(R1 as int) + Cast(R2 as int) + Cast(R3 as int) + Cast(R4 as int) + Cast(R5 as int) + Cast(R6 as int))>=42
and (Cast(R1 as int) + Cast(R2 as int) + Cast(R3 as int) + Cast(R4 as int) + Cast(R5 as int) + Cast(R6 as int))<=158
--连号:[0-4 其中1:320 0:284 2:133 3:18 4:1 此处3与4可不要]
and (Case Cast(R2 as int)-Cast(R1 as int) when 1 then 1 else 0 end)+
(Case Cast(R3 as int)-Cast(R2 as int) when 1 then 1 else 0 end)+
(Case Cast(R4 as int)-Cast(R3 as int) when 1 then 1 else 0 end)+
(Case Cast(R5 as int)-Cast(R4 as int) when 1 then 1 else 0 end)+
(Case Cast(R6 as int)-Cast(R5 as int) when 1 then 1 else 0 end)
 <= 3
and (Case Cast(R2 as int)-Cast(R1 as int) when 1 then 1 else 0 end)+
(Case Cast(R3 as int)-Cast(R2 as int) when 1 then 1 else 0 end)+
(Case Cast(R4 as int)-Cast(R3 as int) when 1 then 1 else 0 end)+
(Case Cast(R5 as int)-Cast(R4 as int) when 1 then 1 else 0 end)+
(Case Cast(R6 as int)-Cast(R5 as int) when 1 then 1 else 0 end)
>= 0
--跨度:[9-32]
-- 可不要或指定其范围
and Cast(R6 as int)-Cast(R1 as int)>=9
and Cast(R6 as int)-Cast(R1 as int)<=32
--重号:[0-3 其中0:500 1:201 2:46 3:9 在此处可以只取0 1]
and
(Case when R1 in
(
select top 1 col001 from aa union
select top 1 col002 from aa union
select top 1 col003 from aa union
select top 1 col004 from aa union
select top 1 col005 from aa union
select top 1 col006 from aa
) then 1 else 0 end)+
(Case when R2 in
(
select top 1 col001 from aa union
select top 1 col002 from aa union
select top 1 col003 from aa union
select top 1 col004 from aa union
select top 1 col005 from aa union
select top 1 col006 from aa
) then 1 else 0 end)+
(Case when R3 in
(
select top 1 col001 from aa union
select top 1 col002 from aa union
select top 1 col003 from aa union
select top 1 col004 from aa union
select top 1 col005 from aa union
select top 1 col006 from aa
) then 1 else 0 end)+
(Case when R4 in
(
select top 1 col001 from aa union
select top 1 col002 from aa union
select top 1 col003 from aa union
select top 1 col004 from aa union
select top 1 col005 from aa union
select top 1 col006 from aa
)
 then 1 else 0 end)+
(Case when R5 in
(
select top 1 col001 from aa union
select top 1 col002 from aa union
select top 1 col003 from aa union
select top 1 col004 from aa union
select top 1 col005 from aa union
select top 1 col006 from aa
)
 then 1 else 0 end)+
(Case when R6 in
(
select top 1 col001 from aa union
select top 1 col002 from aa union
select top 1 col003 from aa union
select top 1 col004 from aa union
select top 1 col005 from aa union
select top 1 col006 from aa
)
 then 1 else 0 end)
<=6
--在前六期出现的个数[0-6 其中 0:1 1:6 2:32 6:74 3:159 5:229 4:255]
and (
Case when r1 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r2 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r3 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r4 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r5 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r6 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)<=5
and (
Case when r1 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r2 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r3 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r4 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r5 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)+
(
Case when r6 in
(
select top 6 col001 from aa union
select top 6 col002 from aa union
select top 6 col003 from aa union
select top 6 col004 from aa union
select top 6 col005 from aa union
select top 6 col006 from aa
) then 1 else 0 end
)>=0
-- 同位同值判断 [0-3 其中0:500 1:201 2:46 3:9 在此处可以只取01]
and
(
case when R1 = (select top 1 col001 from aa) then 1 else 0 end +
case when R2 = (select top 1 col002 from aa) then 1 else 0 end +
case when R3 = (select top 1 col003 from aa) then 1 else 0 end +
case when R4 = (select top 1 col004 from aa) then 1 else 0 end +
case when R5 = (select top 1 col005 from aa) then 1 else 0 end +
case when R6 = (select top 1 col006 from aa) then 1 else 0 end
)>=0
and
(
case when R1 = (select top 1 col001 from aa) then 1 else 0 end +
case when R2 = (select top 1 col002 from aa) then 1 else 0 end +
case when R3 = (select top 1 col003 from aa) then 1 else 0 end +
case when R4 = (select top 1 col004 from aa) then 1 else 0 end +
case when R5 = (select top 1 col005 from aa) then 1 else 0 end +
case when R6 = (select top 1 col006 from aa) then 1 else 0 end
)<=2
-- 区段分布分析 0-11 12-22 23-33
and
case when R1<=11 then 1 else 0 end +
case when R2<=11 then 1 else 0 end +
case when R3<=11 then 1 else 0 end +
case when R4<=11 then 1 else 0 end +
case when R5<=11 then 1 else 0 end +
case when R6<=11 then 1 else 0 end
=2
and
case when R1 >11 and R1<=22 then 1 else 0 end +
case when R2 >11 and R2<=22 then 1 else 0 end +
case when R3 >11 and R3<=22 then 1 else 0 end +
case when R4 >11 and R4<=22 then 1 else 0 end +
case when R5 >11 and R5<=22 then 1 else 0 end +
case when R6 >11 and R6<=22 then 1 else 0 end
=2
--AC值:[2-10 其中2:2 3:3 4:20 5:50 10:67 9:115 6:132 7:154 8:213]

and (select count(*) from
(
select right('0'+Cast(Cast(R6 as int)-Cast(R5 as int) as varchar(10)),2) as a union
select right('0'+Cast(Cast(R6 as int)-Cast(R4 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R6 as int)-Cast(R3 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R6 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R6 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R4 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R3 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R4 as int)-Cast(R3 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R4 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R4 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R3 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R3 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R2 as int)-Cast(R1 as int) as varchar(10)),2)
) A
)-5 <= 9
and (select count(*) from
(
select right('0'+Cast(Cast(R6 as int)-Cast(R5 as int) as varchar(10)),2) as a union
select right('0'+Cast(Cast(R6 as int)-Cast(R4 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R6 as int)-Cast(R3 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R6 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R6 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R4 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R3 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R5 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R4 as int)-Cast(R3 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R4 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R4 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R3 as int)-Cast(R2 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R3 as int)-Cast(R1 as int) as varchar(10)),2) union
select right('0'+Cast(Cast(R2 as int)-Cast(R1 as int) as varchar(10)),2)
) A
)-5 >= 6

hrb2008
关注
专栏目录
最新双色球彩万宝缩水使用方法大全
双彩飞扬的博客
09-24 7697
双色球是深受彩民喜爱的一种玩法，但要从33个号码中选出6个，难度还是比较大的，中奖概率比较低，如果能减少选号数量，那么将大大增加中奖概率，那么我们要通过缩水的方法把一些不可能出现的注数排除 工具/原料 功能：（主功能）彩万宝18大缩水、57大分析图表 （副功能）复盘缩水功能（一键导出或导入缩水条件）、兑奖查询功能、结果保存功能、打印功能等等 希望这些缩水方法和技巧对大家有帮助，下面我们讲解2018...
模具设计之产品缩水
j13712128767的博客
10-24 1193
由于产品是塑料件的原因，在注塑机中处于熔融状态，在填充入模具前与冷却后会发生收缩，在设计模具时必须对其乘缩水率 那么，工作中我们如何对产品进行缩水的设置？ 1先用UG软件打开一个产品 2 我们首先要了解这个产品的材料，比如产品具体是abs，pp，pom…不同的塑性材质其变形量也是不一样。 3我们确定材料后，可以通过客户或资料确定其变形量，也就是缩水率。 4 通过ug软件的变换功能对产品进行缩放比的设置 找到产品的一个基准点。通常我们会选取一些特殊的或重要的点位 并点击确定，复制。这时，我们就会得到.
双色球数据挖掘分析
11-15
不断摸索数据挖掘模型，力争挖掘出双色球的七个数字，红球篮球多少人一生的梦想，争取加入加入500W俱乐部！
使用sql语句分析双色球
congbao6525的博客
05-27 358
这个题目看似有点无厘头，老写技术博客，也来干点“正事",用sql语句分析一下近十年来的双色球情况，不过我肯定算不出来开奖结果，纯属个人娱乐， 个人觉得概率让一切皆有可能，但是用sql语句测试，有些结果还是和大家的想象有很大的出...
双色球必杀技
程序员的良师益友
02-28 1万+
转帖]双色球定号杀号方法大全27个杀红公式 双色球定号杀号方法大全 27个杀红公式 一，当期开奖号码大小顺序第一位与第六位的差，计算的结果在下一期有可能不出。30 二，当期开奖号码大小顺序第二位与第三位的差，计算的结果在下一期有可能不出。11 三，当期开奖号码大小顺序第二位与第五位的差，计算的结果在下一期有可能不出。13 四，当期开奖号码
New SQL
hhkun0120的专栏
06-27 575
是的我看见到处是阳光 快乐在城市上空飘扬 新世纪来得像梦一样 让我暖洋洋
缩水测试软件,快速检测并修复缩水U盘的简单方法
weixin_39947812的博客
07-24 702
快速检测并修复缩水U盘的简单方法U盘的使用已经非常普及，但由于市场上充斥着大量的不良制造商，因此各种假冒伪劣U盘如雨后春笋般的出现，其中缩水U盘就是最让人不想见到的，买的号称16G的U盘结果只有3G，无论是谁都会火大，因此在购买U盘的时候检测U盘是否为缩水也成为了我们必学的本领，下面我们就一起来看看快速检测 并修复缩水U盘的简单方法。1、鉴定自己的u盘是否为缩水u盘，可以上网搜索下载u盘鉴定器，种...
SQL Server数据库指标
culuo4781的博客
07-18 1039
摘要 (Summary) There is a multitude of database metrics that we can collect and use to help us understand database and server resource consumption, as well as overall usage. 我们可以收集和使用大量数据库指标，以帮...
双色球初探
热门推荐
XXX的专栏
08-28 1万+
算法解释 旋转矩阵 概念： 一位被誉为“彩票黑客”的美国人Gail Howard创造的一种叫做“旋转矩阵”投注选号法。据称在美国彩票史上，这位“彩票黑客”运用“旋转矩阵”法，流水般地中出了74个大奖。这是一种基于“旋转矩阵”数学原理构造的选号法，其核心宗旨是：以极低的成本实现复式投注的效果。 一些彩民由于未了解“旋转矩阵”的作用，都采取旧式的复式投注方式(即完全复式)，完完整整地拿去打彩，
Vb6.0双色球数据随机生成器.rar
07-10
Vb6.0双色球包号数据随机生成器，数据生成完成的话，可以选择顺序缩水、概率缩水，可定义数值的最小可能、最大可能。程序仅供学习VB算法，所生成数据并不起任何作用。
超强缩水软件
09-10
【标题】：“超强缩水软件”通常指的是在计算机领域中，一种能够帮助用户减小文件或数据大小的工具，尤其适用于处理大容量的文件，以便更有效地存储、传输或分享。这种软件通过各种压缩算法，将文件的数据进行优化，...
VB版福彩超级大乐透缩水选号器
07-18
VB写的相对专业的福彩超级大乐透缩水选号器，具有前区号码、后区号码任意选，随机选的功能，可以进行前区总值和后区总值以及前...
VB编译 双色球随机软件
03-10
【VB编译 双色球随机软件】 VB（Visual Basic）是Microsoft公司推出的一种面向对象的、事件驱动的编程语言，它是基于Basic语言的基础之上，加入了更多现代化的编程特性。在本项目中，“双色球随机软件”是利用VB...
双色球助手2.0---最新发布----完全免费
Android
05-29 7431
注意：暂时不提供天空、华军、多特等软件站点下载 软件官网：双色球助手 软件下载：猛点击下载 1.双色球助手是一款完全免费的双色球选号，缩水（精确定位与模糊范围过滤并存），查看走势图一体的超级购彩助手！ 提示：支持导出所有市面网站上传格式 2.选号面板展示 1.机选手选面板 2.定心机选面板 3.胆拖选号面板 4.螺旋矩阵选号面板 5.六期选号面板 6.六...
缩水u盘的快速检测方法
weixin_43969945的博客
07-25 774
缩水U盘、扩容盘快速鉴别方法 快速判断一个U盘、存储卡是不是扩展盘，缩水U盘。其中提供了常见的检测手段，以及一种和网上不太相同的检测手段。希望能够帮助大家购买到自己所需要的U盘。 ...
sqlserver中全文检索与csw(测试版)实现分词查询测试
05-16 5376
分词搜索后台准备工作一、将数据1,2020,1,海口君澜商贸有限公司                                                                                ,海南省海口市机场路群芳花园４号                                                                     
mysql中处理指定分隔符分隔的字符串,取范围例子
04-22 3000
函数主要实现指定标点符号分隔的各数据间处理.适用于类似打页面面范围等数据的精确提取.如打印范围1-3,8,9-12之类的情况.示例中对处理手机号段进行了处理,第一行中的1300,1301等为手机前四位号码.其余各行为手机子号段范围.以,及-符号分隔.为精确取到手机整个号段.需要将手机子号段范围精确到每一个值,如970-972,980需要处理为1300970,13009
windows搭建apache,php,mysql环境并设置虚拟目录
11-21 2298
1.在d盘下新建web文件夹,新建apache mysql php 三个子目录2.双击mysqlforwindows.exe安装mysql，选择自定义（custom）安装，安装至d盘web/mysql下3.双击apache_2.2.4-win32-x86-no_ssl.msi安装apache服务器,选择自定义（custom）安装，安装至d盘web/apche下4.双击php-5.1.4-insta
SQL Server日期时间数据类型与数据库管理详解
课程大纲覆盖了SQL Server的相关基础知识，包括但不限于SQL Server简介，数据库的基本管理和T-SQL语句，多表查询，约束和索引，视图，游标，存储过程的创建和使用，用户自定义函数，触发器，以及数据库的管理与项目...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值