CODEWITHSUNDEEP
phpsqlmysql
sam
sam

Reputation: 51

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,30;

Upvotes: 0

Views: 72

Answers (1)

timdev
timdev

Reputation: 62874

WHERE Clauses come before ORDER BY.

Rewrite as:

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

Upvotes: 3

Related Questions