I have a db
name age date
| adl-01 | 47.00 | 06/19/2016 08:30:00 |
| adl-01 | 47.00 | 06/19/2016 09:45:00 |
| adl-01 | 46.00 | 06/19/2016 16:00:00 |
| rtdl-01 | 45.00 | 06/19/2016 07:00:00 |
| erdl-01 | 45.00 | 06/19/2016 10:00:00 |
| adl-01 | 45.00 | 06/19/2016 12:00:00 |
| tydl-01 | 45.00 | 06/19/2016 09:30:00 |
I want to find max age for a all distinct name with linked time stamp. But whenever I'm grouping by date column, it just gives all values. Without date, I'm able to get desired output but I need the time-stamp attached with the max age for that name.
SELECT name,MAX(age),date FROM pop
WHERE name LIKE '%dl%'
AND date >= TO_DATE('2016-06-19 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND date <= TO_DATE('2016-06-20 00:00:00','YYYY-MM-DD HH24:MI:SS')
GROUP BY name ,date
order by 1,3
Any help plz?