SQL语句

SQL Server

"select top 1  GYSBH from Gys order by  convert(int,   GYSBH) desc"; //查询最大编号


Oracle

select * from CATEGORIE where fid = 187 order by  TO_NUMBER(ISAUDITING)