Question

SQL2005 修改表数据

数据表this，所有A列相同的数据，将B列依次排序。请教了！

Answer 1

修改表的什么数据呢?
数据表this，所有A列相同的数据，将B列依次排序
如果只是检索的话,那是
SELECT
*
FROM
this
ORDER BY
A, B

如果你是要增加一个 对于相同的A ， 把 B 依次排序后， 有序号的话

SELECT
A,
B,
ROW_NUMBER() OVER ( PARTITION BY A ORDER BY B) AS No
FROM
this
ORDER BY
A, B

Answer 2

SELECT
*
FROM
this
ORDER BY
A, B

如果你是要增加一个 对于相同的A ， 把 B 依次排序后， 有序号的话

SELECT
A,
B,
ROW_NUMBER() OVER ( PARTITION BY A ORDER BY B) AS No
FROM
this
ORDER BY
A, B

Answer 3

select * from this order by a,b

Answer 4

SELECT * FROM this ORDER BY A, B可以了

Answer 5

土土土土