|
最新即時行情 |
日期 |
買高 |
前買高 |
買漲跌 |
買幅(%) |
賣低 |
前賣低 |
賣漲跌 |
賣幅(%) |
SELECT Com_Information.cmpName, Quo.* FROM (SELECT ISNULL(buy.日期, sell.日期) AS 日期, ISNULL(buy.Hot, sell.Hot) AS Hot, ISNULL(buy.cmpNo, sell.cmpNo) AS cmpNo, buy.買高, buy.前買高, ROUND(buy.買漲跌,2) AS 買漲跌, ROUND(buy.買幅,2) AS 買幅, sell.賣低, sell.前賣低, ROUND(sell.賣漲跌, 2) AS 賣漲跌, ROUND(sell.賣幅, 2) AS 賣幅 FROM (SELECT D_DAY.*, P_DAY.前買高, CONVERT(real, D_DAY.買高) - CONVERT(real, P_DAY.前買高) AS 買漲跌, (CONVERT(real, D_DAY.買高) - CONVERT(real, P_DAY.前買高)) / CONVERT(real, P_DAY.前買高) * 100 AS 買幅 FROM (SELECT 日期, cmpNo, 買高, Hot FROM Stock_Quotation WHERE (ISNUMERIC(買高) = 1) AND (日期 = '2024/5/15')) D_DAY LEFT OUTER JOIN (SELECT 日期, cmpNo, 買高 AS 前買高 FROM Stock_Quotation WHERE (ISNUMERIC(買高) = 1) AND (買高 > '0.00') AND (日期 = '2024/5/14')) P_DAY ON D_DAY.cmpNo = P_DAY.cmpNo) buy FULL OUTER JOIN (SELECT D_DAY2.*, P_DAY2.前賣低, CONVERT(real, D_DAY2.賣低) - CONVERT(real, P_DAY2.前賣低) AS 賣漲跌, (CONVERT(real, D_DAY2.賣低) - CONVERT(real, P_DAY2.前賣低)) / CONVERT(real, P_DAY2.前賣低) * 100 AS 賣幅 FROM (SELECT 日期, cmpNo, 賣低, Hot FROM Stock_Quotation WHERE (ISNUMERIC(賣低) = 1) AND (日期 = '2024/5/15')) D_DAY2 LEFT OUTER JOIN (SELECT 日期, cmpNo, 賣低 AS 前賣低 FROM Stock_Quotation WHERE (ISNUMERIC(賣低) = 1) AND (賣低 > '0.00') AND (日期 = '2024/5/14')) P_DAY2 ON D_DAY2.cmpNo = P_DAY2.cmpNo) sell ON buy.cmpNo = sell.cmpNo) Quo INNER JOIN Com_Information ON Quo.cmpNo COLLATE Chinese_Taiwan_Stroke_CI_AS = Com_Information.cmpNo WHERE Com_Information.cmpId = '18716' 交易 (處理序識別碼 56) 在 鎖定 資源上被另一個處理序鎖死並已被選擇作為死結的犧牲者。請重新執行該交易。 | |