OVER (PARTITION BY) Not working on ZOHO QUERY TABLES

OVER (PARTITION BY) Not working on ZOHO QUERY TABLES

Is this code impossible with Zoho Query Tables?


  1. Select "ID","Campaign",  COUNT("ID") OVER (PARTITION BY "ID") AS "# of Attempts"
  2. FROM "Calls"

It works on SQL Express and in Zoho but the problem is, Zoho displays one row and the total count and sql displays all rows with my expected result.


http://technet.microsoft.com/en-us/library/ms189461.aspx