SELECT Field1, Field2, SUM(Field3) AS Field3,MIN(Field4) AS Field4
FROM TheTable
GROUP BY Field1, Field2;

quote:

---

Originally posted by mmalaka

There is no role...I do not care about it..but I need to select a value from both records...randomly or the top 1...

---

SELECT  Field1, Field2,Field3, Field4
FROM
(
SELECT Field1, Field2, SUM(Field3) OVER PARTITION BY (Field1, Field2) AS Field3, Field4,ROW_NUMBER() OVER (PARTITION BY Field1, Field2 ORDER BY Field4) AS Seq
FROM Table
)t
WHERE Seq=1