I need to a condition on my select where I would get the latest (id) row if the query will return more than one result. (IBM db2)

I.e:

```
ID--NUM1--COUNTRY--NUM2

1--123--SE--123

2--123--US--123

```

Instead of having the two rows returned I would like to have row 2 returned.

**EDIT:**

My query looks like this now:

```
SELECT   LET1.INSTANCE_ID, COU.CODE, SUP1.SUPPLIERID, PAR.PARTNUMBER 

FROM     TABLES

WHERE    TABLEJOIN_CONDITIONS

AND      TABLE.COLUMN IN ('11994', '12345' and so on)

```

But this query can return duplicate rows.

Like:

```
ID--NUM1--COUNTRY--NUM2

1--123--SE--11994 (11994 appearing twice, then I want the latest row which is row number 2)

2--123--US--11994

```