Merge two rows in SQL

you haven't specified a grouping criteria, so something like this will work for your sample data and results, but may need to be changed for an expanded data set


select max(fk) fk, max(field1) field1, max(field2) field2 from yourtable

GROUP BY
    FK;

Group by FK value 1 and 2
Giving a new row with 2 in the FK field

The table will have 450 rows. 1 and 2 in the FK field with a StudentID.  Sorry for not specifying the StudentID earlier.

StudentID |FK | Field1 | Field2
=====================
A0203340 |1  | ABC    | *NULL*
A0203340 |2  | *NULL* | DEF
is there a way I can perform a select on the table to get the following

StudentID |FK | Field1 | Field2
=====================
A0203340 |2  | ABC    | DEF

Grouping is done by StudentID and FX.