select * from (select ROW_NUMBER()over(order by id) as num_no,* from tb_user_login_track)rs where rs.num_no>0 and rs.num_no<6 1-5条
1,插入时间,就不做解释,将实体字段的类型定义为Timestamp类型,hibernet和ibatis框架都会自动插入带时分秒的格式。 2,分页,给个sql你看看就好了select A.ID id,A.ConcentratorAddress concentratorAddress,A.MeterAddress meterAddress,A.userNo userNo, A.ThinkTypename thinkTypename,A.ThinkFlag thinkFlag,a.UserName userName,A.Sign sign,A.UploadData uploadData,A.OccurDate occurDate,A.UploadDate uploadDate from (select ROW_NUMBER() over(order by eau.OccurDate desc,eau.id) as rownum, eau.id,eau.ConcentratorAddress,'' as MeterAddress,'' as userNo, case when eau.ThinkTypename='1' then '已处理' else '未处理' end as ThinkTypename, eau.ThinkTypename as ThinkFlag,'' as UserName,eau.Sign,eau.UpLoadData ,eau.OccurDate, eau.UpLoadDate from egmActiveUpLoad eau where right(eau.Sign,7) = ',14,10,' ) A where rownum between $startNum$ and $endNum$
select top 50 * from (select row_number()over(order by id)rownumber,* from pagetest)a where rownumber>9900
Date date = new Date();
要sql还是hql?
2,分页,给个sql你看看就好了select A.ID id,A.ConcentratorAddress
concentratorAddress,A.MeterAddress meterAddress,A.userNo userNo,
A.ThinkTypename thinkTypename,A.ThinkFlag thinkFlag,a.UserName
userName,A.Sign sign,A.UploadData uploadData,A.OccurDate
occurDate,A.UploadDate uploadDate
from (select ROW_NUMBER() over(order by eau.OccurDate desc,eau.id) as rownum,
eau.id,eau.ConcentratorAddress,'' as MeterAddress,'' as userNo,
case when eau.ThinkTypename='1' then '已处理' else '未处理' end as
ThinkTypename,
eau.ThinkTypename as ThinkFlag,'' as UserName,eau.Sign,eau.UpLoadData ,eau.OccurDate,
eau.UpLoadDate
from egmActiveUpLoad eau where right(eau.Sign,7) = ',14,10,'
) A where rownum between $startNum$ and $endNum$
(select row_number()over(order by id)rownumber,* from pagetest)a
where rownumber>9900
数据库中fbtime是什么格式?
数据库中fbtime是什么格式?成功了,大哥谢谢,我少了单引号呵呵,谢谢 撒分