select * from articles where turn=1 order by sj desc limit 0,4
请先select * from articles 看看
top 5语句只适合:Microsoft SQL Server and Access MySQL and PostgreSQL : select * from table limit N Oracle 8i : select * from (select * from table) where rownum <= N
DB2: select * from table fetch first 5 rows only Informix: select first 5 * from table Microsoft SQL Server and Access :select top 5 * from table MySQL and PostgreSQL :select * from table limit 5 Oracle 8i: select * from (select * from table) where rownum <= 5
MySQL and PostgreSQL : select * from table limit N
Oracle 8i : select * from (select * from table) where rownum <= N
Informix: select first 5 * from table
Microsoft SQL Server and Access :select top 5 * from table
MySQL and PostgreSQL :select * from table limit 5
Oracle 8i: select * from (select * from table) where rownum <= 5