Using the following query, SELECT o.persistent_key_str, o.ord_idFROM orders o WHERE o.ord_submitted_date in ( SELECT min(ord_submitted_date)ord_date FROM ordersgroup by persistent_key_str) I was able to generate the following output: <http://postgresql.nabble.com/file/n5828394/First_time_orders.png> The customer who placed two orders on the same date also appears in the result set. Thanks, Ron -- View this message in context: http://postgresql.nabble.com/generating-the-average-6-months-spend-excluding-first-orders-tp5828253p5828394.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных