Hi,

I have mytable that contains 2 fields:

id date
aaa 20101006
aaa 20100906

bbb 20101007
bbb 20100907

to create newtable with 2 records left from 4 above:
aaa 20101006

bbb 20101007

I need to have a sql syntax to do this.

TIA