//1,先对表中的num进行排升序
//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';
Oracle排序后查询某条数据的rownum
最新推荐文章于 2023-05-24 18:24:11 发布