Distinct For Only One Column

[Solved] Distinct For Only One Column | Perl - Code Explorer | yomemimo.com

Question : sql distinct only one column

Answered by : david-cortesi

SELECT DISTINCT column_name
FROM table_name

Source : | Last Update : Wed, 23 Feb 22

Question : distinct For only one column

Answered by : otmane-smiri

SELECT * FROM ( SELECT ID, Email, ProductName, ProductModel, ROW_NUMBER() OVER(PARTITION BY Email ORDER BY ID DESC) rn FROM Products ) a
WHERE rn = 1

Source : https://stackoverflow.com/questions/5021693/distinct-for-only-one-column | Last Update : Wed, 13 Jul 22

yomemimo.com