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