SQLServer基础运用三

delete from 表名
where 比较的最小值的列 not in(
select b.minnum from(
select min(比较的最小值的列) minnum
from 表名 group by 列名
)b
)

2.
DELETE FROM Table_1
WHERE age=50
AND ID NOT in(
    SELECT MIN(ID)
    FROM Table_1
    WHERE Age = 50
    GROUP BY age
);