从cpcode表中查询出90-100的10条记录
SQLServer:
[code]select * from (select top 10 * from (select top 100 * from cpcode order by code) a order by code desc) as b order by code
[/code]
Oracle:
[code]select * from (select rownum as rn1,code,name from cpcode where rownum<=100) where rn1 >=91 [/code]
MySQL:
[code]select * from cpcode limit 90,10[/code]
SQLServer:
[code]select * from (select top 10 * from (select top 100 * from cpcode order by code) a order by code desc) as b order by code
[/code]
Oracle:
[code]select * from (select rownum as rn1,code,name from cpcode where rownum<=100) where rn1 >=91 [/code]
MySQL:
[code]select * from cpcode limit 90,10[/code]
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
