from http://blog.csdn.net/flyingpig204/article/details/4195896
MySQL中不支持TOP语句,而在SQL Server 和 sybase中才有效.
MySQL中
select * from tablename order by orderfield desc/asc limit position,counter;position 指示从哪里开始查询,如果是0则是从头开始,counter 表示查询的个数取前15条记录:select * from tablename order by orderfield desc/asc limit 0,15新闻热点
疑难解答