Q: SQL server min and MAX date I have a table with below data

i want the output as 

EMP 25FC0938-88EE has 3 entries. The ID against the oldest date should be entered in column A and rest in Column B.
How can i achieve this in SQL

A: You can use first_value() :
select firstvalue as columnA, id as columnB
from (select *, first_value(id) over (partition by us order by date) as firstvalue
      from table
     ) t
where id <> firstvalue;

If you want to insert the result-set of the preceding query then use INSERT . . INTO statement
insert into table (columnA, columnB)
select firstvalue as columnA, id as columnB
from (select *, first_value(id) over (partition by us order by date) as firstvalue
      from table
     ) t
where id <> firstvalue;

