ansaurus

Question

Answer 1

+6 A:

SELECT Name, COUNT(*) FROM EntryLog WHERE CheckIn GROUP BY Name

Sjoerd 2010-07-20 11:42:05

+1 beat me to it :)

Adam 2010-07-20 11:43:08

+1 Beat me, too.

Brian Hooper 2010-07-20 11:44:47

Also note that to get the record count result, use `cursor.moveToFirst()` and then get the number in the first field of the result record: `cursor.getInt(0)`

Brad Hein 2010-07-20 14:59:42

@Brad, wouldn't it be `cursor.getInt(1)`? Or better yet, using the `Cursor.getColumnIndex` method

Hamy 2010-07-21 03:41:32

@Brad - You sure? Correct me if i am wrong, but I am fairly confident that SELECT NAME, Count(\*) will return 2 fields, one named 'Name' and one named 'Count(\*)'. If this is correct, then calling getInt(0) will attempt to get an integer from the first field, which would be the column named 'Name'. This may/may not throw an error. It seems to me that the OP will want to use `cursor.getString(0)` to get the 'Name' column and `cursor.getInt(1)` to get the count column.

Hamy 2010-07-28 19:11:09

@Hamy thank you for catching my mistake. Since two fields are being queried there will be two fields in the cursor. The first field is "Name" and the second is the count which we are after. So you would want `getInt(1)` just as you stated.

Brad Hein 2010-07-29 11:32:54

@Brad - cool, glad we agree!

Hamy 2010-07-29 16:02:32

Answer 2

+4 A:

Try:

SELECT COUNT(1) FROM EntryLog WHERE CheckIn = 1 GROUP BY [Name]

Adam 2010-07-20 11:42:32

but does it fetch only records where CheckIn is true?

Codevalley 2010-07-20 11:50:04

No, but surely you can implement that part yourself? - Does now. The important bit was the aggregation via the Group By IMHO.

Adam 2010-07-20 11:51:51

Answer 3

+3 A:

SELECT name,
       COUNT(*)
    FROM EntryLog
    WHERE CheckIn
    GROUP BY name;

Brian Hooper 2010-07-20 11:43:46

ansaurus

tags:

views:

answers:

SQL query to count records.

related questions