christianbernard

try this against MSSQL DB

WITH LatestConnections AS (

SELECT

Username,

StartDateTime,

ROW_NUMBER() OVER (PARTITION BY Username ORDER BY StartDateTime DESC) AS rn

FROM [CyberRDM].[dbo].[ConnectionLog]

)

SELECT

Username,

StartDateTime

FROM

LatestConnections

WHERE

rn = 1

ORDER BY

StartDateTime DESC;