SELECT (b.C6 / b.C2 - 1)* 100 upAndDown,
b.c6 closingPrice,a.stkCode,a.stkName,b.c1 tradingDay FROM ST205_main b
INNER JOIN(
SELECT a.co stkCode,a.c8 stkName,MAX(b.c1)c1,MIN(b.c1)c11 FROM ST41500_main a
LEFT JOIN ST205_main b ON a.co = b.co
WHERE a.C2 = 106547
AND a.C7 = - 1
AND a.C10 = 1
AND(
a.CO LIKE 'NY%'
OR a.CO LIKE 'NS%')
AND b.c1 BETWEEN 20111120000000 AND 20121120000000
GROUP BY a.co)a ON a.stkCode = b.co AND (a.c1 = b.c1 OR a.c11 = b.c1)
b.c6 closingPrice,a.stkCode,a.stkName,b.c1 tradingDay FROM ST205_main b
INNER JOIN(
SELECT a.co stkCode,a.c8 stkName,MAX(b.c1)c1,MIN(b.c1)c11 FROM ST41500_main a
LEFT JOIN ST205_main b ON a.co = b.co
WHERE a.C2 = 106547
AND a.C7 = - 1
AND a.C10 = 1
AND(
a.CO LIKE 'NY%'
OR a.CO LIKE 'NS%')
AND b.c1 BETWEEN 20111120000000 AND 20121120000000
GROUP BY a.co)a ON a.stkCode = b.co AND (a.c1 = b.c1 OR a.c11 = b.c1)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货