将 SQL 查询转换为 IBatis/MyBatis 查询

Question

我是Ibatis新手，还在学习。 我遇到了这个SQL查询，需要转换为Ibatis查询。

我尝试输入CDATA标签，也尝试了一些迭代器标签，但它对我来说不起作用。 这是我的查询：

SELECT comp_small_name
FROM table_company
WHERE companyid IN (
        SELECT agentid
        FROM (
            SELECT *
            FROM table_comp_price
            WHERE companyid = #compid#
            ORDER BY companyid DESC
            WHERE ROWNUM <= 2
            )
        )

这适用于Oracle数据库。

Answer 1

Method 1

SELECT comp_small_name
    FROM table_company
    WHERE companyid IN (
            SELECT agentid
            FROM (
                SELECT *
                FROM table_comp_price
                WHERE companyid = #compid
                ORDER BY companyid DESC
                WHERE <![CDATA[ ROWNUM <= 2 ]]>
                )
            )

或者您也可以使用以下Method 2：

 SELECT comp_small_name
    FROM table_company
    WHERE companyid IN (
            SELECT agentid
            FROM (
                SELECT *
                FROM table_comp_price
                WHERE companyid = #compid
                ORDER BY companyid DESC
                WHERE ROWNUM <= 2
                )
            )