参见英文答案 >
How to update and order by using ms sql5个答案我的查询
UPDATE TOP (1) TX_Master_PCBA
SET TIMESTAMP2 = '2013-12-12 15:40:31.593'
WHERE SERIAL_NO IN ('0500030309')
ORDER BY TIMESTAMP2 DESC
使用TX_Master_PCBA表中的serial_No列我有10条记录，但我想将最新的TIMESTAMP2更新为当前日期时间。
Incorrect Syntax near the keyword ‘TOP’.
解决方法
WITH UpdateList_view AS (
SELECT TOP 1 * from TX_Master_PCBA
WHERE SERIAL_NO IN ('0500030309')
ORDER BY TIMESTAMP2 DESC
)
update UpdateList_view
set TIMESTAMP2 = '2013-12-12 15:40:31.593'
