SQL SERVER QUERY

SELECT * FROM E200 order by id;

delete e200 where %%physloc%%

not in(select min(%%physloc%%) from e200

group by id,name,job,sal,comm,deptno,mgr)

select name,%%physloc%% as rid from e200

select id,name, min(%%physloc%%)

from e200

group by id,name

order by id