Merhaba, WITH CTE AS (SELECT mac_adresi, tarih, ROW_NUMBER() OVER (PARTITION BY mac_adresi ORDER BY tarih DESC) AS siraFROM erisim_loglari)SELECT mac_adresi, tarihFROM CTEWHERE sira = 1;