如何在Sql Server中交换行? [英] How Can I Interchange Rows In Sql Server?
本文介绍了如何在Sql Server中交换行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在sql server中交换两行
例如:
ID名称优先年龄
1知更鸟1 23
2 anish 2 24
i需要交换优先级为
ID名称优先年龄
1知更鸟2 23
2 anish 1 24
感谢adavance
解决方案
试试这个:
更新表1
SET priority =
CASE id
WHEN 1 那么( SELECT priority FROM Table_1 WHERE id = 2 )
WHEN 2 那么( SELECT priority FROM Table_1 WHERE id = 1 )
END
WHERE id IN ( 1 , 2 )
How can i interchange two rows in sql server
eg:
ID name priority age
1 robin 1 23
2 anish 2 24
i need to interchange the priority as
ID name priority age
1 robin 2 23
2 anish 1 24
Thanks in adavance
解决方案
Try this:
UPDATE Table_1 SET priority = CASE id WHEN 1 THEN (SELECT priority FROM Table_1 WHERE id = 2) WHEN 2 THEN (SELECT priority FROM Table_1 WHERE id = 1) END WHERE id IN (1, 2)
这篇关于如何在Sql Server中交换行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文