这条SQL语句怎样写? select * from tablename where id between 1 and 100 order by id desc; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from tablename where id between 1 and 100 order by id desc; select * from TableName where id between 1 and 100 order by id; select * from table where id >=1 and i <=100 order by id desc; select * from table where id >=1 and i <=100 order by id desc; SELECT ID FROM TABNAME WHERE ID>1 AND ID<1OO ORDER BY ID; SELECT ID FROM TABNAME WHERE ID>=1 AND ID<=1OO ORDER BY ID desc; select * from tablename where id between 1 and 100 order by id desc; select * from (select rownum ID from table_name) where id >= 1 and id <= 100 order by id desc 请教关于重做日志文件和归档模式的问题 求oracle的教程 Oracle10g XP安装中的问题 求助高手!! 请教个sqlcode的问题,fetch不到数据的时候 ORACLE SQL 查询结果集怎么拼接?? 问一个数据库链路的问题 如何写SQL语句? 再问exp,imp问题 如何解决Oracle 8i 的SQLPlus Worksheet中简体中文显示为乱码的问题? 我是个初学者,请各位高手帮助以下,我进入SQL*Plus时连接数据库怎么一直是连接失败? sqlplus汉字显示问题,谢谢。 过程中用了dbms_output.put_line(sqlstr)后怎么看输出?
(select rownum ID from table_name) where id >= 1 and id <= 100 order by id desc