Home > Database > Mysql Tutorial > mysql复杂查询语句求助

mysql复杂查询语句求助

WBOY
Release: 2016-06-06 09:43:26
Original
999 people have browsed it

mysql查询语句jsp

现在有一个表a,里面有一列为time,jsp中有两个变量fnum(本页首数),lnum(本页尾数)
,如何实现按照time倒序排列并且每页在fnum,lnum之间呢
select * from a where time limit fnum,lnum order by time desc??这样感觉不大对。。。求大虾解答

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template