Fetch first row only with IN operation in DB2
<p>how do i use "fetch first row only" in combination with "in" operator? something like </p>

<pre><code>select user_id, item_name as last_item_name 
from sale 
where user_id in (1,2) 
order by date desc 
fetch first row only
</code></pre>

<p>which i want it to returns the last item each person buy?
eg: running the query on</p>

<pre><code>--------------------------------
id | user_id | item_name| date |
1  | 1       | pen      | 01/01|
2  | 1       | book     | 02/01|
3  | 2       | book     | 01/01|
4  | 2       | computer | 02/01|
--------------------------------
</code></pre>

<p>should return</p>

<pre><code>user_id | last_item_name|
1       | book          |
2       | computer      |
-------------------------
</code></pre>

<p>Thanks!</p>