My current query is as follows:

select count(distinct pdf_name) from qas_issue where
record_disposition ='BLOCKED' and db_inserted between '01-APR-2010'
and '01-MAY-2010'

What is the correct syntax for usin a range?

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to