Given the following table:
TAB1
COL1 COL2
—– —–
A 10
B 20
C 30
A 10
D 40
C 30
Assuming the following results are desired:
TAB1
COL1 COL2
—– —–
A 10
B 20
C 30
D 40
Which of the following statements will produce the desired results?

A.
SELECT UNIQUE * FROM tab1

B.
SELECT DISTINCT * FROM tab1

C.
SELECTUNIQUE(*) FROM tab1

D.
SELECTDISTINCT(*) FROM tab1