Here's a more efficient way to do it: ```SELECT I...
# suiteql
t
Here's a more efficient way to do it:
Copy code
SELECT
	ID,
	TranID,
	Type,
	TranDate
FROM
	Transaction
WHERE
	TranDate >= TO_DATE( '2021-06-08', 'YYYY-MM-DD' )
	AND TranDate < TO_DATE( '2021-06-09', 'YYYY-MM-DD' )