Get one column DISTINCT value from SQL Server

https://cloud.githubusercontent.com/assets/4152211/26547733/19b0f3c2-448e-11e7-810e-c778ececb0ab.png
##########################################
WITH CTE
AS
(
   SELECT *,
     ROW_NUMBER() OVER(PARTITION BY ID_FORMA_PAGO
                       ORDER BY ID_FORMA_PAGO DESC) AS RN
   FROM dbo.FORMA_PAGO_SITE
)
SELECT ID_FORMA_PAGO_SITE, ID_SITE, ID_FORMA_PAGO, NOMBRE_FORMA_PAGO
FROM CTE
WHERE RN = 1 AND ID_SITE IN (318);
##########################################
##########################################
select * from (SELECT * FROM FORMA_PAGO_SITE WHERE
ID_FORMA_PAGO_SITE in (SELECT MAX(ID_FORMA_PAGO_SITE) FROM FORMA_PAGO_SITE GROUP BY ID_FORMA_PAGO)) as a where a.ID_SITE IN (318)
##########################################

For Your reference :