WITH a1 AS (SELECT * ,ROW_NUMBER() OVER (ORDER BY CLIENT_ID DESC,CNAME DESC ) AS a2
FROM client)
SELECT * FROM a1
sql With ROW_NUMBER() 使用 生成查询行号
最新推荐文章于 2024-01-04 00:01:15 发布
WITH a1 AS (SELECT * ,ROW_NUMBER() OVER (ORDER BY CLIENT_ID DESC,CNAME DESC ) AS a2
FROM client)
SELECT * FROM a1