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 表示查詢的個(gè)數(shù)取前15條記錄:select * from tablename order by orderfield desc/asc limit 0,15新聞熱點(diǎn)
疑難解答
圖片精選