How to get only the first value in a table?

Question

PostgreSQL

There is a request:

SELECT to_char(date, 'YYYY-MM-dd HH24:MI:ss') as day,
  title, email, price, pages
FROM customer

Получаю ответ:
1. 2016-10-26 09:51:57 Title 1 [email protected] 5 10
2. 2016-10-26 09:51:40 Title 1 [email protected] 5 10
3. 2016-10-26 09:51:20 Title 1 [email protected] 5 10
4. 2016-10-26 09:51:10 Title 1 [email protected] 5 10
5. 2016-10-26 19:51:10 Title 2 [email protected] 5 10
6. 2016-10-26 19:00:10 Title 2 [email protected] 5 10
Всё одинаково, кроме секунд в дате. Подскажите, пожалуйста, как мне получить только одно значение, первое попадание в базу. В моем случае это пункт 4 и 6

Answer 1

SELECT DISTINCT ON (day),
  to_char(date, 'YYYY-MM-dd HH24:MI:ss') as day, title, email, price, pages
FROM customer

Answer 2

С учётом изменения вопроса:

SELECT to_char(c.date, 'YYYY-MM-dd HH24:MI:ss') as day,
       c.title, c.email, c.price, c.pages
  FROM (
    SELECT MIN(date) AS date, email FROM customer GROUP BY email
  ) AS t
  JOIN customer AS c ON c.date = t.date AND c.email = d.email

Answer 3

MIN(date) вместе с group by