On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> The query I would like to end up with is:
>
> SELECT
> session_id, count(*) count
> FROM
> events
> WHERE
> session_id IN (1,2,3)
> GROUP BY
> session_id
Try this :
<select id="findCountsBySession" parameterClass="list" resultMap="counts">
SELECT
session_id as id, count(*) count
FROM
events
<dynamic prepend="WHERE">
<iterate property="value" open="session_id IN (" close=")"
conjunction=",">
#value[]#
</iterate>
</dynamic>
GROUP BY
session_id
</select>
Regards.
