select * from tbak where rownum <&dd order by 1 desc;该怎么解决
select * from tbak where rownum <&dd order by 1 desc;
order by 1 的1是什么意思啊.tbak是系统预定义的表吗
------解决方案--------------------
order by 1 的1是什么意思啊.tbak是系统预定义的表吗
------解决方案--------------------
- SQL code
--例如: select a,b,c,d,e,f,g from t order by 1,3,5; --等价于 select a,b,c,d,e,f,g from t order by a,c,e; select a,m,d,c,b from t order by 1,3,5; --等价于 select a,m,d,c,b from t order by a,d,b; 说白了就是前面select 中的字段顺序对应的字段。