zcgw.net
当前位置:首页 >> sqlmAxlimit >>

sqlmAxlimit

select * From table where id = (select max(id) from table))

SELECT id from job_01 order by id desc limit 1 (mysql)SELECT top 1 id from job_01 order by id desc (sql server)

SELECT SUM(avg_p) FROM ( select avg_p from hs300_sql WHERE created_at=(SELECT MAX(created_at) FROM hs300_sql) AND period='06s' ORDER BY quanzhong DESC )k limit 149;

query.setFirstResult(1500);query.setMaxResults(15); 是基于数据库sql语句的分页方式,对于hibernate分页我只用过两种 1.query.setFirstResult();query.setMaxResults(); 基于数据库sql 2.query.scroll(); 基于内存分页 第一种方式,hibernat...

网站首页 | 网站地图
All rights reserved Powered by www.zcgw.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com