SQL Distinct

Question

Hello,

I have record like below pic and need to filter so the output only have one record for each NodeID and sort by InstallDate. How I can do this by SQL?

Answer 1

You can use an aggregation, like

SELECT NodeID, MIN(InstallDate) AS MinInstallDate
FROM yourTable
GROUP BY NodeID
ORDER BY MinInstallDate