如何从两个重复的行中更新单个行 [英] How to update a single rows from a two duplicate rows

问题描述

一个表有两行具有相同的值.
两行的每个字段都具有相同的值.
现在，我只需要更新一行即可避免重复.
现在，使用"top 1"关键字选择第一行.但是如何更新.

A table have 2 rows with same values.
Both rows each fields have same value.
Now I need to update only one row to avoid duplicate purpose.
Now select first row using ''top 1 '' keyword. But how can update.

推荐答案

原来，您可以执行SELECT并在UPDATE的FROM上分配它.参见下文.

Turns out you can do a SELECT and assign it on the FROM of the UPDATE. See below.

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

请参见此处 [

See here[^] for reference.

这篇关于如何从两个重复的行中更新单个行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！