Data Segrigation Issue

[#1]

Hi Folks,

my actual table

Comm No	LotNo
1	a
2	a
3	a
4	a
5	a
6	a
1	b
2	b
3	b
4	b
5	b
6	b
1	c
2	c
3	c
4	c
5	c
6	c

My Required Data is

COMM_NO	LOT NO
1	a
2	a
3	b
4	b
5	c
6	c

Pls help ..

[Anonymous]

Can you try to explain what exactly are you trying to achieve here..

[#3]

Dear Aadil,

             I need, if distint(count(comm_no)/count(lot_no)) = x

            Then First x distinct(Comm_no) Should have first Lot_No

             and second X distinct(comm_no) should have Second Lot_NO,

             and Third X distinct(comm_no) should have Third Lot_no,

         for example see my previous posting

Thanks