symis
中學生
離線
文章: 80
|
假設有個table 叫aaa, 內容有2個欄位,如下: a1 a2 ----- ----- a 1 b 2 c 3 ----------------------------- 語法: select * from ( select max(aaa1.a2) as a2_max from aaa aaa1 inner join ( select * from aaa where a2 = (select max(a2) from aaa) ) aaa2 on aaa1.a1=aaa2.a1 ) x ----------------------------- 錯誤訊息: 伺服器: 訊息 8624,層級 16,狀態 3,行 1 Internal SQL Server error. ----------------------------- 請問,問題的關鍵在哪? thanks!
|