34,571
社区成员
发帖
与我相关
我的任务
分享
NUMBER HIGH
----------- -----------
1 2
2 4
3 8
4 16
5 32
6 64
7 128
8 1
9 2
10 4
11 8
12 16
(12 行受影响)
CREATE VIEW NUMBER_VIEW
AS
SELECT TOP 100 PERCENT
NUMBER,HIGH
FROM
MASTER..SPT_VALUES
WHERE
TYPE='P'
AND
NUMBER BETWEEN 1 AND 12 ORDER BY HIGH DESC
SELECT * FROM NUMBER_VIEW
NUMBER HIGH
----------- -----------
7 128
6 64
5 32
4 16
12 16
11 8
3 8
2 4
10 4
9 2
1 2
8 1
(所影响的行数为 12 行)
DROP VIEW NUMBER_VIEW
select * from View_test order by Col1