mysql rownum in hibernate

411 阅读1分钟
SELECT (@rownum /*'*/:=/*'*/@rownum+1) as rownum, a.* FROM tablename a, (select @rownum /*'*/:=/*'*/0) as init