14,494 questions
You can use an aggregation, like
SELECT NodeID, MIN(InstallDate) AS MinInstallDate
FROM yourTable
GROUP BY NodeID
ORDER BY MinInstallDate
SQL Distinct
Handian Sudianto
6,096
Reputation points
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?
SQL Server Other
Accepted answer
-
Olaf Helper 47,436 Reputation points2024-07-18T07:49:41.5566667+00:00 -
Handian Sudianto 6,096 Reputation points
2024-07-18T08:22:20.17+00:00 Hi..
it's work , thanks.
-
LiHongMSFT-4306 31,566 Reputation points2024-07-19T01:28:50.96+00:00 If this answer is helpful to your question, you can accept it as an answer so that other users with similar questions can see it more easily. :)
Sign in to comment -