SQL (SELECT DISTINCT ON)

[liviox]

Выборка уникальных значений с сортировкой по выбранному полю.

SELECT * FROM (
SELECT DISTINCT ON (field1) field1, time_field FROM table
) as tbl
ORDER BY time_field DESC