SELECT Com_Information.cmpName, Com_Information.stkNo, Stock_Quotation.買高, Replace(Replace(Stock_Quotation.買漲跌,'▼ -','▼'),'▲ +','▲') AS 買漲跌, Replace(Replace(Replace(Stock_Quotation.買幅,'0.00%','0%'),'+0%','0%'),'-0%','0%') AS 買幅, Stock_Quotation.賣低, Replace(Replace(Stock_Quotation.賣漲跌,'▼ -','▼'),'▲ +','▲') AS 賣漲跌, Replace(Replace(Replace(Stock_Quotation.賣幅,'-0%','0%'),'+0%','0%'),'0.00%','0%') AS 賣幅, Stock_Quotation.Hot AS 熱門股 FROM Stock_Quotation INNER JOIN Com_Information ON Stock_Quotation.cmpNo = Com_Information.cmpNo WHERE (Stock_Quotation.日期 = CONVERT(DATETIME, '2024/04/19', 102)) ORDER BY Convert(real,Replace(Replace(Replace(Replace(本益比,'議價','-99999'),'▲',''),'▼','-'),'%','')) DESC
無效的資料行名稱 '本益比'。