create table test(id int, val char(5));
insert into test values(1, 'red');
insert into test values(2, 'green');
insert into test values(3, 'blue');
insert into test values(2, 'green');*/
delete from test
where test.ID in (select id from test GROUP BY id HAVING count(id)>1);
What results must be and why?select * from test;id value
-- -----
01 red
02 green
03 blueORid value
-- -----
01 red
03 blue

[Non-text portions of this message have been removed]