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.