Question

一道数据库题，求高手解答！！！答对追加分！

已知SQL Server2005数据库中有一数据表P定义如下:
CREATE TABLE P ( ID uniqueidentifier Primary key, Number int ）并且该表现有数据如下： ID Number
1 5
2 34
3 1
4 56
5 -9
请使用SQL语句查询出该表中Number字段值从小到大的次序，如下结果所示：
ID Number 次序
1 5 3
2 34 4
3 1 2
4 56 5
5 -9 1

Answer 1

SELECT id,number,RANK() OVER(ORDER BY number DESC) AS '次序' FROM p
select * from p order by Number asc

Answer 2

SELECT id,number,RANK() OVER(ORDER BY number DESC) AS '次序' FROM p

Answer 3

select * from p order by Number asc

哥哥，我的绝对对的，记得给我分。

Answer 4

declare @t table (
ID int, Number int
)

insert into @t
SELECT 1,5 UNION ALL
SELECT 2,34 UNION ALL
SELECT 3,1 UNION ALL
SELECT 4,56 UNION ALL
SELECT 5,-9

SELECT id
,number
,row_number() over (order by number) as [次序]
FROM @t
order by id

用最后一句，把@t改成自己的表名

Answer 5

select ID , Number,row_number() over(order by id) as "次序"
from P;

Answer 6

row_number() over(order by 列名 顺序)
rank() over(order by 列名 顺序)
dense_rank() over(order by 列名 顺序)
用次序函数……
select ID,Number,row_number() over(order by Number asc) as '次序' from P order by ID asc