27,580
社区成员
发帖
与我相关
我的任务
分享
--增加一个排序列,想改排序方式了,把排序表的内容换一下就是了
USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
IF OBJECT_ID('orderT') IS NOT NULL DROP TABLE orderT
GO
CREATE TABLE t(id INT IDENTITY(1,1) PRIMARY KEY,n INT)
CREATE TABLE orderT(n INT PRIMARY KEY,orderBy INT)
INSERT INTO t(n) VALUES(2)
INSERT INTO t(n) VALUES(3)
INSERT INTO t(n) VALUES(1)
INSERT INTO t(n) VALUES(4)
INSERT INTO t(n) VALUES(2)
INSERT INTO orderT(n,orderBy)
SELECT 2,1
UNION ALL SELECT 1,2
UNION ALL SELECT 3,3
UNION ALL SELECT 4,4
SELECT * FROM t INNER JOIN orderT AS ot ON t.n=ot.n
ORDER BY ot.orderBy
/*
id n n orderBy
1 2 2 1
5 2 2 1
3 1 1 2
2 3 3 3
4 4 4 4
*/