postgresql 分页

来源:互联网 发布:知乎的精华帖在哪 编辑:程序博客网 时间:2024/05/16 14:51
  select topictrave0_.id as col_0_0_, topictrave0_.topicname as col_1_0_, topictrave0_.summary as col_2_0_ 
  from d_topicTravel topictrave0_ order by topictrave0_.id desc limit 8 offset 0

offset 偏移量 0表示从第一条开始
limit 共取几条 10表示本次查询10条
原创粉丝点击