Hi to all.
I have a table with these columns:
table_id, date_time, customer, other_fields
One customer could have several records in the same date and I have to make a
SELECT only to the first table_id for a given date for each customer_id. I have
worked around the query with something like this but I haven't succeed:
SELECT
xx0.table_id
FROM
my_table xx0
WHERE
xx0.date_time >= CAST('today' AS DATE) + 1
AND xx0.date_time < CAST('today' AS DATE) + 2
AND xx0.table_id IN (
SELECT FIRST 1
xx2.table_id
FROM
my_table xx2
WHERE
xx2.date_time >= CAST('today' AS DATE) + 1
AND xx2.date_time < CAST('today' AS DATE) + 2
AND xx2.customer_id IN (
SELECT DISTINCT
xx1.customer_id
FROM
my_table xx1
WHERE
xx1.date_time >= CAST('today' AS DATE) + 1
AND xx1.date_time < CAST('today' AS DATE) + 2
)
ORDER BY
xx2.date_time
)
ORDER BY
xx0.date_time
Any help will be appreciated.
Best regards,
Hernando.
