search

OData / odataorg.github.io

Staging site and collaboration repository for http://www.odata.org
MIT License
63 stars 101 forks source link

How can I change SQL Query to Odata Query #83

Open Sam00900 opened 8 years ago

Sam00900 commented 8 years ago

Hi, How can I convert This SQL Query to Odata Query

SELECT FirstName, LastName, MobileNo, COUNT(1) as CNT FROM CUSTOMER GROUP BY FirstName, LastName, MobileNo;

monty241 commented 7 years ago

A possible way is to use the online sql editor. It is closed source but when you execute this query using sql on an OData source such as exact online you can find the OData calls in select * from sessionios