开发者

sql query returns error when using limit

why does this query work? how am i supposed to write it?

select * from tbl_content order by year desc where visible = '1' limit 0,3开发者_如何学Go0;


WHERE Clauses come before ORDER BY.

Rewrite as:

select * from tbl_content where visible = '1'  order by year desc limit 0,30;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜