SELECT ticker,`datetime` FROM ( SELECT ticker, MAX(`datetime`) `datetime` FROM Bloomberg_hist_data GROUP BY ticker ) t ORDER BY `datetime`
SELECT ticker,`datetime` FROM ( SELECT ticker, MAX(`datetime`) `datetime` FROM Bloomberg_hist_data GROUP BY ticker ) t ORDER BY `datetime`