Kir Kolyshkin Голосов: 1 Адрес блога: http://k001.livejournal.com/ Добавлен: 2008-02-19 12:45:30 блограйдером Lurk

sql

2013-04-11 21:55:59 (читать в оригинале)

Are there any SQL experts here? Which one is more effective to get the most recent submission? I am using MySQL with InnoDB, if that matters, 'time' field is of type timestamp, and of course there's an index on time.

SELECT MAX(time) FROM submissions;

or

SELECT time FROM submissions ORDER BY time DESC LIMIT 0,1;

And why.