例如：
table a
id name 1 tom 2 Jery 3 Jack 4 MaryOracle：select rownum ,id,name from (select * from tableName order by cond);
Sql Server：select row_number() over (order by name desc) as rowNum,id,name from a order by name desc本文共 271 字，大约阅读时间需要 1 分钟。
例如：
table a
id name 1 tom 2 Jery 3 Jack 4 MaryOracle：select rownum ,id,name from (select * from tableName order by cond);
Sql Server：select row_number() over (order by name desc) as rowNum,id,name from a order by name desc转载于:https://my.oschina.net/yangphere/blog/59793