mysql - Oracle MySQL 等效代码

Question

执行以下操作的等效 Oracle(11g) 代码是什么:

For MySQL

ps = con.prepareStatement("select SQL_CALC_FOUND_ROWS from student_details where UPPER(name) like UPPER(?) limit " + offset + ", " + noOfRecords);

和rs = ps.executeQuery("SELECT FOUND_ROWS()");

Answer 1

尝试这样:

SELECT *
FROM (select t.*, rownum rn, count(*) over() as SQL_CALC_FOUND_ROWS
        from student_details t
       where UPPER(name) like UPPER(?))
WHERE rn <= offset 

“SQL_CALC_FOUND_ROWS”中返回的值将是如果没有 WHERE rn <= offset 则将选择的记录数。条款