每日一练14

13

表名：team

ID(number型) Name(varchar2型)

1                 a

2                 b

3                 b

4                 a

5                 c

6                 c

要求:执行一个删除语句，当Name列上有相同时,只保留ID这列上值小的

例如：删除后的结果应如下:

ID(number型) Name(varchar2型)

1                 a

2                 b

5                 c

请写出SQL语句。

Delete from team where Name not in (select MIN(Name) from team groupby Name );