如何得到一个表中按照某字段排列的第4-8条记录? select top 5 * from (select top 8 * from table order by fld) a order by fld desc 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from (select * from table order by field1) where rownum>4 and rownum<8 这是oracle8中的 如果keyfield为unique,可以select top 4 * from yourtable where keyfield not in (select top 4 keyfield from yourtable order by orderfield) order by orderfield select * from (select * from table order by field1) where rownum>4 and rownum<8 这是oracle8中的这是错误的。 select * from tablewhere rownum<=8minus select * from tablewhere rownum<=4 但应是TOP 5select top 4 * from yourtable where keyfield not in (select top 4 keyfield from yourtable order by orderfield) order by orderfield select * from table order by xx limit 4,8这是mysql的。 救急!!!求一段SQL语法,关于instr的用法 连接Excel搜索空值, 如何传递给空值OleDbParameter 大家能帮我看看怎么修改吗 SQL 2005 备份到C盘问题 access中的ole对象字段与sql server中哪个字段对应? 拼凑的sql语句超过8000个字符怎么办? 自增长数据类型如何定义? 求SQL語句 (***求助SQL大牛)一个很复杂的SQL语句 连接SQL SERVER6.5时出错 请教一个关于性能/速度方面的问题! 100分--强烈需要高手指点!
where rownum<=8
minus
select * from table
where rownum<=4
select top 4 * from yourtable where keyfield not in (select top 4 keyfield from yourtable order by orderfield) order by orderfield
这是mysql的。