What's wrong with my query? Filter by date and email address
Hi all,
Please help. I'm looking for tickets that were received from a particular email address, submitted between a date range.
SELECT
email,
ticket_number,
ds
FROM
table
WHERE
email = 'xxxxx@gmail.com'
AND ds BETWEEN '2016-01-01'
AND '2016-11-01'
ORDER BY
ds ASC;
Shows no results even though it should. What am I missing here, did wrong here? please help, if not the right place, please redirect me. thanks. #NOOBS
Subject
Written By
Posted
What's wrong with my query? Filter by date and email address
November 19, 2017 02:05AM
November 19, 2017 09:31AM
November 20, 2017 05:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.