Select Distinct Count of Records

(0) Share

Report

Posted on by brianmaric

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

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

This is a duplicate, The same post is already in your thread Count Records with Group by.

Was this reply helpful? Yes No