varunfilim (7/29/2010)

---

Hi friends,

I have a scenario where the table values are

ID First Second

162

142

122

261

241

221

From this table I want to generate a combination where Next ID values is max(previous ID) ie 3 and a combination of first and second which didnt come in the Previous combination, for eg

3 6 2

3 4 1

3 2 2

Can any solve this issue...help appreciated...