Skip to Content
0
Feb 16, 2009 at 10:16 AM

Duplicates in a database table

188 Views

Hi !

I have a database table. It has 4 fields. 3 of them are key.

Table (f1,f2,f3,f4)

f1,f2,f3: key

f4: numeric field.

From a ABAP program, I can insert (using insert sentence) two records with the same key. why ???

Then, if I try ....

select f1 f2 f3 sum(f4)

from table

group by f1 f2 f3

... it doesn´t work. This sentence returns two records. Why ?

(some fields of the key can be nulls)

Thanks.