SELECT Com_Information.cmpName, Rotc_Quotation.報買價, Rotc_Quotation.報買量, Rotc_Quotation.買幅 as 買漲幅, Rotc_Quotation.報賣價, Rotc_Quotation.報賣量, Rotc_Quotation.賣幅 AS 賣漲幅, Rotc_Quotation.前均價, Rotc_Quotation.日均價, Rotc_Quotation.日最高, Rotc_Quotation.成交價, Rotc_Quotation.成交量, Rotc_Quotation.漲跌幅, Rotc_Quotation.cmpNo FROM Rotc_Quotation INNER JOIN Com_Information ON Rotc_Quotation.cmpNo = Com_Information.cmpNo WHERE (Rotc_Quotation.日期 = '2024/6/7 下午 03:37:00') ORDER BY 漲跌幅 DESC
無效的資料行名稱 '漲跌幅'。 |
