Question

求教大神，下面这句sql语句是不是有语法错误，报错说关键字 'and' 附近有语法错误。

sql="select * from (select *,row_number() over(order by time desc) as rownum from picuser where status=1)t where rownum>='"+startNum +"'and rownum<='"+endNum+"'";
status在数据库是int字段

Answer 1

and前加一个空格试试