sql server - How to update and order by using ms sql - Stack Overflow

2009年3月17日 - WITH q AS ( SELECT TOP 10 * FROM messages WHERE status = 0 ORDER BY priority DESC ) UPDATE q SET status = 10 ...

stackoverflow.com