why do you want to remove the GROUP BY ? Is it stopping you doing something else or not working ?

Its not effecient but you can try sub queries.

SELECT

emp.empid,

total_sales = (SELECT SUM(value) FROM sales WHERE sales.empid = emp.empid),

last_sale (SELECT MAX(date) FROM sales WHERE sales.empid = emp.empid)

FROM emp