I have an entity called 'saleslineEnity' and I want to get the the number of salesid's without having to loop through all the records because there are so many. I tried this:
select count(RecId) from salesLinesEntity Group by SalesId
but it doesn't work
I guess I could make a direct call to the database:
str sql = 'select count(distinct Salesid) from salesLineEntity';
*This post is locked for comments
This is a duplicate, The same post is already in your thread Count Records with Group by.
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156