select
greatest (t.t630645,t.t645700,t.t645700,t.t715730,t.t730745,t.t745800,t.t800815,t.t815830,t.t830845,t.t845900,
t.t900915,t.t915930,t.t830845,t.t845900,t.t9451000,t.t10001015,t.t10151030,t.t10301045,t.t10451100,
t.t11001115,t.t11151130,t.t11301145,t.t11451200,t.t12001215,t.t12151230,t.t12301245,t.t12451300,
t.t13001315,t.t13151330,t.t13301345,t.t13451400,t.t14001415,t.t14151430,t.t14301445,t.t14451500,
t.t16001615,t.t15151530,t.t15301545,t.t15451600,t.t16001615,t.t16151630,t.t16301645,t.t16451700,
t.t17001715,t.t17151730,t.t17301745,t.t17451800,t.t18001815,t.t18151830,t.t18301845,t.t18451900,
t.t19001915,t.t19151930,t.t19301945,t.t19452000,t.t20002015,t.t20152030,t.t20302045,t.t20452100,
t.t21002115,t.t21152130,t.t21302145,t.t21452200,t.t22002215,t.t22152230,t.t22302245,t.t22452300,
t.t23002315,t.t23152330,t.t23302345,t.t23452400)
from (
select
max(t630_645) t630645,max(t645_700) t645700,
max(t700_715) t700715,max(t715_730) t715730,(t730_745) t730745,(t745_800) t745800,
max(t800_815) t800815,max(t815_830) t815830,(t830_845) t830845,(t845_900) t845900,
max(t900_915) t900915,max(t915_930) t915930,(t930_945) t930945,(t945_1000) t9451000,
max(t1000_1015) t10001015,max(t1015_1030) t10151030,max(t1030_1045) t10301045,max(t1045_1100) t10451100,
max(t1100_1115) t11001115,max(t1115_1130) t11151130,max(t1130_1145) t11301145,max(t1145_1200) t11451200,
max(t1200_1215) t12001215,max(t1215_1230) t12151230,max(t1230_1245) t12301245,max(t1245_1300) t12451300,
max(t1300_1315) t13001315,max(t1315_1330) t13151330,max(t1330_1345) t13301345,max(t1345_1400) t13451400,
max(t1400_1415) t14001415,max(t1415_1430) t14151430,max(t1430_1445) t14301445,max(t1445_1500) t14451500,
max(t1500_1515) t15001515,max(t1515_1530) t15151530,max(t1530_1545) t15301545,max(t1545_1600) t15451600,
max(t1600_1615) t16001615,max(t1615_1630) t16151630,max(t1630_1645) t16301645,max(t1645_1700) t16451700,
max(t1700_1715) t17001715,max(t1715_1730) t17151730,max(t1730_1745) t17301745,max(t1745_1800) t17451800,
max(t1800_1815) t18001815,max(t1815_1830) t18151830,max(t1830_1845) t18301845,max(t1845_1900) t18451900,
max(t1900_1915) t19001915,max(t1915_1930) t19151930,max(t1930_1945) t19301945,max(t1945_2000) t19452000,
max(t2000_2015) t20002015,max(t2015_2030) t20152030,max(t2030_2045) t20302045,max(t2045_2100) t20452100,
max(t2100_2115) t21002115,max(t2115_2130) t21152130,max(t2130_2145) t21302145,max(t2145_2200) t21452200,
max(t2200_2215) t22002215,max(t2215_2230) t22152230,max(t2230_2245) t22302245,max(t2245_2300) t22452300,
max(t2300_2315) t23002315,max(t2315_2330) t23152330,max(t2330_2345) t23302345,max(t2345_2400) t23452400
FROM `ods_gdxt_gd_fifteen_num_base_view` e
where trade_date between '2021-08-01 00:00:00' and '2021-09-01 00:00:00'
) t
select
LEAST (t.t630645,t.t645700,t.t645700,t.t715730,t.t730745,t.t745800,t.t800815,t.t815830,t.t830845,t.t845900,
t.t900915,t.t915930,t.t830845,t.t845900,t.t9451000,t.t10001015,t.t10151030,t.t10301045,t.t10451100,
t.t11001115,t.t11151130,t.t11301145,t.t11451200,t.t12001215,t.t12151230,t.t12301245,t.t12451300,
t.t13001315,t.t13151330,t.t13301345,t.t13451400,t.t14001415,t.t14151430,t.t14301445,t.t14451500,
t.t16001615,t.t15151530,t.t15301545,t.t15451600,t.t16001615,t.t16151630,t.t16301645,t.t16451700,
t.t17001715,t.t17151730,t.t17301745,t.t17451800,t.t18001815,t.t18151830,t.t18301845,t.t18451900,
t.t19001915,t.t19151930,t.t19301945,t.t19452000,t.t20002015,t.t20152030,t.t20302045,t.t20452100,
t.t21002115,t.t21152130,t.t21302145,t.t21452200,t.t22002215,t.t22152230,t.t22302245,t.t22452300,
t.t23002315,t.t23152330,t.t23302345,t.t23452400)
from (
select
max(t630_645) t630645,max(t645_700) t645700,
max(t700_715) t700715,max(t715_730) t715730,(t730_745) t730745,(t745_800) t745800,
max(t800_815) t800815,max(t815_830) t815830,(t830_845) t830845,(t845_900) t845900,
max(t900_915) t900915,max(t915_930) t915930,(t930_945) t930945,(t945_1000) t9451000,
max(t1000_1015) t10001015,max(t1015_1030) t10151030,max(t1030_1045) t10301045,max(t1045_1100) t10451100,
max(t1100_1115) t11001115,max(t1115_1130) t11151130,max(t1130_1145) t11301145,max(t1145_1200) t11451200,
max(t1200_1215) t12001215,max(t1215_1230) t12151230,max(t1230_1245) t12301245,max(t1245_1300) t12451300,
max(t1300_1315) t13001315,max(t1315_1330) t13151330,max(t1330_1345) t13301345,max(t1345_1400) t13451400,
max(t1400_1415) t14001415,max(t1415_1430) t14151430,max(t1430_1445) t14301445,max(t1445_1500) t14451500,
max(t1500_1515) t15001515,max(t1515_1530) t15151530,max(t1530_1545) t15301545,max(t1545_1600) t15451600,
max(t1600_1615) t16001615,max(t1615_1630) t16151630,max(t1630_1645) t16301645,max(t1645_1700) t16451700,
max(t1700_1715) t17001715,max(t1715_1730) t17151730,max(t1730_1745) t17301745,max(t1745_1800) t17451800,
max(t1800_1815) t18001815,max(t1815_1830) t18151830,max(t1830_1845) t18301845,max(t1845_1900) t18451900,
max(t1900_1915) t19001915,max(t1915_1930) t19151930,max(t1930_1945) t19301945,max(t1945_2000) t19452000,
max(t2000_2015) t20002015,max(t2015_2030) t20152030,max(t2030_2045) t20302045,max(t2045_2100) t20452100,
max(t2100_2115) t21002115,max(t2115_2130) t21152130,max(t2130_2145) t21302145,max(t2145_2200) t21452200,
max(t2200_2215) t22002215,max(t2215_2230) t22152230,max(t2230_2245) t22302245,max(t2245_2300) t22452300,
max(t2300_2315) t23002315,max(t2315_2330) t23152330,max(t2330_2345) t23302345,max(t2345_2400) t23452400
FROM `ods_gdxt_gd_fifteen_num_base_view` e
where trade_date between '2021-08-01 00:00:00' and '2021-09-01 00:00:00'
) t
Mysql计算一行最大最小值
最新推荐文章于 2023-04-12 21:25:07 发布