SELECT DATE_FORMAT(MASA,'%d-%m-%Y') AS dtTarikh, TPLC.* FROM TPLC WHERE KODSEK = 'NEA6006' AND TPLC.KAT='1' GROUP BY TPLC.KODSEK WITH ROLLUP