oracle和mysql随机数的问题
ExercisePaperDAOImpl// 查询训练记忆试题
public List findTTMemory(int userid, int ttid, int ttgid) {
String sql = "select * from tbTTrainMemory where userid=? and ttid=? and ttgid=? order by dbms_random.value";
Object[] args = { userid, ttid, ttgid };
return basedao.getJdbcTemplate().queryForList(sql, args);
}
几个参数值为
userid =1 ttid =41ttgid=21
select * from tbTTrainMemory where userid=1 and ttid=41 and ttgid=21 order by dbms_random.value
转变成mysql后
select * from tbTTrainMemory where userid=1 and ttid=41 and ttgid=21 order by rand();
页:
[1]