Jump to content

Talk:Update (SQL)

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 70.169.134.132 (talk) at 07:31, 16 February 2006. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

This is valid in Microsoft SQL server:

UPDATE authors SET state = 'ZZ' FROM (SELECT TOP 10 * FROM authors ORDER BY au_lname) AS t1 WHERE authors.au_id = t1.au_id

Retrieved from "https://en.wikipedia.org/w/index.php?title=Talk:Update_(SQL)&oldid=39850102"