1-) MSSQL Athena -  AYNI İSİMDE OLANLARI 1 KEZ GETİRİR

SELECT * FROM (SELECT  *,ROW_NUMBER() OVER (PARTITION BY PSICIL_MER_NIS ORDER BY PSICIL_ADI DESC) AS [ROW NUMBER]FROM PSICIL ) Groups WHERE groups.[ROW NUMBER] = 1 ORDER BY groups.PSICIL_ADI DESC