MVSFORUMS.com

[rublu]

Hi all,

I have a table T1. In that I have 2 fields ID and VALUE.

T1
---
ID VALUE
***********

For each ID there are about 1000 values present.

Now my question was, I want a query which will select 2 values for each ID, though there present more than 2 records for that particular ID.

i.e. the out put should be like

T1
---
ID - VALUE
************
1 - a
1 - b
2 - a
2 - c
3 - f
3 - g

Is it possible to control the rows for each key...?
_________________
------------
Ruben

[kolusu]

rublu,

Try this sql. I did not get a chance to test it