sql

show last values

select * from info;

'1', 'PHOTO', '2015-02-02 00:00:00', '1240'
'2', 'PHOTO', '2014-12-02 00:00:00', '1240'
'3', 'GALLERY', '2014-12-07 00:00:00', '651'
'4', 'IMAGE', '2014-02-02 00:00:00', '845'
'5', 'REVIEW', '2019-02-02 00:00:00', '7485'
'6', 'GALLERY', '2014-02-02 00:00:00', '7485'
'7', 'PHOTO', '2014-02-02 00:00:00', '453'
'8', 'GALLERY', '2017-02-02 00:00:00', '7486786'
'9', 'IMAGE', '2014-02-02 00:00:00', '45345'
'10', 'GALLERY', '2013-03-02 00:00:00', '456453'
'11', 'PHOTO', '2014-08-02 00:00:00', '312345'
'12', 'IMAGE', '2014-03-02 00:00:00', '78678'
'13', 'REVIEW', '2015-02-02 00:00:00', '786'

select result:

'PHOTO', '1240'
'REVIEW', '7485'
'GALLERY', '7486786'
'IMAGE', '78678'