sql查询分页语句

 

 sql = "select * from tableName where "+条件+" order by "+排序+" limit "+要显示多少条记录+" offset "+跳过多少条记录;

如: select * from tableName limit 12 offset 20     意思是说:   从tableName表跳过20条记录选出12条记录