Filter the unique records

[Former Member]

Hi ,

for writting a code for "filter the unquie records based on EXNUM AND EXYEAR"

I HAVE WRITTEN

"delete the adjacent duplicate from y_v_delivery(defined)

comparing EXNUM EXYEAR"

IS IT CORRECT OR NOT

[Former Member]

Hi,

It is correct, Provided you have sorted the table.

Reward if useful!

[Former Member]

Hi Bijender,

First Use SORT for the same.

SORT y_v_delivery BY EXNUM EXYEAR.

And then use DELETE..which is correct.

Reward points if useful.

Regards,

Atish

[Former Member]

THANKS .........HOW TO GIVE THE POINTS TELL ME THE PROCEDURE.

[Former Member]

There are points near each answer. Just click on that radio button.

Regards,

Atish