Last post Oct 19, 2017 05:46 PM by PatriceSc
Oct 19, 2017 02:08 PM|20141113|LINK
i have two column, 1st column store the "ID and date" format (IDXXX-YYYYMMDD) where IDXXX is the record ID and 2nd column store the time. how can i retrieve the record which is latest date and latest time for each ID in sql in oracle?
my expected result as below
Oct 19, 2017 05:46 PM|PatriceSc|LINK
Not familiar with Oracle but my understanding is that you want something such as :
SELECT MAX(ID_DATE+TIME) FROM Table GROUP BY LEFT(ID_DATE,5) which should show :
the problem being that your first column store both an id and a date while date and time that should work together are splitted.