已知表Table(a,b,c,d)四个字段,请按c进行排序,取排序后的11-20条记录。
(1)用mysql进行排序
select * from table order by c desc limit 11 ,20
(2)oracle的实现方式
select * from (selct ROWNUM ro ,Table.* from( select * from Table order by c desc)) T where T.no>10 and T.no<=20;
已知表Table(a,b,c,d)四个字段,请按c进行排序,取排序后的11-20条记录。
(1)用mysql进行排序
select * from table order by c desc limit 11 ,20
(2)oracle的实现方式
select * from (selct ROWNUM ro ,Table.* from( select * from Table order by c desc)) T where T.no>10 and T.no<=20;