SELECT Com_Information.cmpName, Com_Information.stkNo, Rotc_Quotation.報買價, Replace(Convert(nvarchar, Rotc_Quotation.買幅) + '%','-0%','0%') AS 買幅, Rotc_Quotation.報賣價, Replace(Convert(nvarchar, Rotc_Quotation.賣幅) + '%','-0%','0%') AS 賣幅, Rotc_Quotation.成交價, Rotc_Quotation.成交量 AS 熱門股, Replace(Convert(nvarchar,((Rotc_Quotation.成交價 - Rotc_Quotation.前均價) / Rotc_Quotation.前均價 * 100)) + '%','-0%','0%') AS 漲跌幅 FROM Rotc_Quotation INNER JOIN Com_Information ON Rotc_Quotation.cmpNo = Com_Information.cmpNo WHERE (Rotc_Quotation.日期 = CONVERT(DATETIME, '2024/05/02', 102)) ORDER BY Convert(real,Rotc_Quotation.漲跌幅) DESC
無效的資料行名稱 '漲跌幅'。