Converting SQL Query to IBatis/MyBatis Query

Question

I am new to Ibatis and still learning it. I encountered this SQL query which needs to be converted in to an Ibatis query.

I tried putting in CDATA tag and tried some iterator tag also, but it didn't work out for me. Here's my query:

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
            )
        )

This is intended for an Oracle database.

SiddP · Accepted Answer · 2016-06-07 04:45:51Z

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 ]]>
                )
            )

or you can also use as below 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 &lt;= 2
                )
            )

edited Jun 7, 2016 at 4:45

answered Jun 6, 2016 at 22:05

SiddP

1,6712 gold badges15 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting SQL Query to IBatis/MyBatis Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related