Hi!
As far as I know H2 does not support OVER.
Mikael
Den 2018-10-24 kl. 07:28, skrev Sriveena Mattaparthi:
Do we support over() clause in SQL in ignite like
select count(*) over() totalrecords from EMPLOYEE;
please confirm.
Thanks & Regards,
Sriveena
“Confidentiality Notice: The contents of this email message and any
attachments are intended solely for the addressee(s) and may contain
confidential and/or privileged information and may be legally
protected from disclosure. If you are not the intended recipient of
this message or their agent, or if this message has been addressed to
you in error, please immediately alert the sender by reply email and
then delete this message and any attachments. If you are not the
intended recipient, you are hereby notified that any use,
dissemination, copying, or storage of this message or its attachments
is strictly prohibited.”