Group by with MIN()

Posts   
 
    
Saswat
User
Posts: 12
Joined: 08-Jan-2014
# Posted on: 30-Jul-2014 14:59:07   

I need to write this query in self servicing.

select DESCRIPTION, min(TAXGROUPID) as TAXGROUPID, TAXGROUPSERIALNUMBER from TAXGROUP group by DESCRIPTION, TAXGROUPSERIALNUMBER

Suggest me.

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 30-Jul-2014 19:13:39   

For a custom resultSet you need a Dynamic List Then check how to use expressions on fields.

Finally you can add a Group By clause to fetch method.

Saswat
User
Posts: 12
Joined: 08-Jan-2014
# Posted on: 30-Jul-2014 19:46:19   

From typedview how I can get group by clause ?

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 30-Jul-2014 22:18:49   

Why are you using a typedView? Are you using fields from a typedView?