Oracle排序后查询某条数据的rownum
//1，先对表中的num进行排升序
www.2cto.com
//2，查询排序后各自的rownum值
//3，查询num='3339999'排序后的rownum值
select temprow from (select rownum as temprow,num from
(select num from mob_num_info order by num)) where num='3339999';
(select num from mob_num_info order by num)) where num='3339999';