FAQ Database Discussion Community


finding max value from duplicate value in mysql

mysql,postgresql,mangodb
I am having a table structure like this: Date Count name 2015-03-05 154903 AAA 2015-03-04 153591 AAA 2015-03-03 151277 AAA 2015-03-06 93997 BBB 2015-03-03 93294 BBB 2015-03-02 79006 BBB 2015-03-08 77324 BBB 2015-03-06 144588 AAA 2015-03-07 144119 AAA 2015-03-02 133543 AAA 2015-03-01 124435 AAA 2015-03-08 115227 AAA 2015-03-05 98866 BBB...

Conditionally group and sum of the elements from an array

java,mongodb,mongodb-query,mangodb
I want to group by APPName and I want find how many PrestoBarImpression, PrestoKeyCountChange, PrestoTileImpression for every application for a particular day (just the sum of order counts). This is so I can generate a report with this information. I need how many order counts of PrestoTileImpression, how many order...