标签：use sheet GreenDao share How popover post data se

How to use SUM and DINSTINCT with GreenDao querybuilder?

Ask Question Asked 7 years ago Modified 6 years, 7 months ago Viewed 1k times  Part of Mobile Development Collective   Report this ad 2

I want to get the sum of total rows in a column of a table in SqlLite Database. I am using GreenDao Library. I know I Have to use SUM. But I don't know how to use it with GreenDao queryBuilder. Can anybody help me? and also DISTINCT.

• android
• greendao
• greendao-generator
• greendao3

Share Edit Follow Flag   edited Nov 24, 2016 at 17:16     asked Nov 16, 2016 at 15:03 Naroju 2,64744 gold badges2525 silver badges4545 bronze badges Add a comment

1 Answer

Sorted by:Reset to default                                                Highest score (default)                                                                     Trending (recent votes count more)                                                                     Date modified (newest first)                                                                     Date created (oldest first)                                2  

This is how I did it. Assume there is the Company entity and it has the numOfEmployees field:

Cursor cursor = daoSession.getDatabase().rawQuery("SELECT SUM(" + Company Dao.Properties.NumOfEmployees.columnName + ") FROM " + Company Dao.TABLENAME, new String []{});
cursor.moveToFirst();
long result = cursor.getLong(0);

Note that you could hardcode the column and table names above, but this is way cleaner.

Share Edit Follow Flag   answered Apr 10, 2017 at 17:44 javaxian 1,82211 gold badge2121 silver badges2626 bronze badges Add a comment  

Your Answer

标签：use,sheet,GreenDao,share,How,popover,post,data,se
From： https://www.cnblogs.com/ioriwellings/p/17836011.html