A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.
2 of 3 added 99 characters in body
SELECT id
     , SUBSTRING(MAX(time || name) FROM 11) "name"
     , SUBSTRING(MAX(time || title) FROM 11) title
     , MAX(time) "time"
FROM test_table
GROUP BY id