Skip to Content
Jun 26, 2020 at 12:24 PM

SAP hana View exclude aggregation

77 Views Last edit Jun 26, 2020 at 12:25 PM 2 rev

i have 2 rows

1 john smith 10 objects

2 john smith 10 objects

i need to group by last name but only show 10 in objects. this has to be done in aggregation or using SQl..

what i see is

john smith 20 objects

i wanna see

john smith 10 objects.

any ideas?>

i am on the latest SAP hana