Skip to Content
0
Former Member
Dec 05, 2006 at 02:18 PM

Simple report program

24 Views

Hi everyone,

I have two fields namely PERNR and PERID in the table xxxxxx.

PERNR is a unique key field where as PERID is not a unique key.

In the table i have the value as follows

PERNR PERID

65000392 717734001

65000393 717734001

65000394 717734000

65000395 717734002

65000396 717734003

65000397 717734003

What operation can be done so that the output I should get is

The duplicate records are:

PERNR PERID

65000392 717734001

65000393 717734001

65000396 717734003

65000397 717734003

Kindly help in making this output.Thanx in advance.