Select max value from multiple column

Jika kita punya tabel :

lalu kita ingin mencari nilai max dari masing2 id, maka kita bisa menggunakan syntax :
SELECT     NAMATABEL.IDCOLOUMN, MAX(t.val) AS NILAIMAX
FROM         NAMATABEL INNER JOIN
                          (SELECT     IDCOLOUMN, NILAI1 AS val
                            FROM          NAMATABEL
                            UNION ALL
                            SELECT     IDCOLOUMN, NILAI2 AS val
                            FROM         NAMATABEL
                            UNION ALL
                            SELECT     IDCOLOUMN, NILAI3 AS val
                            FROM         NAMATABEL
                            UNION ALL
                            SELECT     IDCOLOUMN, NILAI4 AS val
                            FROM         NAMATABEL) t ON NAMATABEL.IDCOLOUMN = t.IDCOLOUMN COLLATE SQL_Latin1_General_CP1_CI_AS
GROUP BY NAMATABEL.IDCOLOUMN

Maka akan dihasilkan nilai seperti :

Semoga bermanfaat