getting count one in very first time but the field is null when using count query

Question

getting count value 1 in very first time but the field is null value, when using count query and If i am inserting any data into this field then count value remains 1 and then again i insert next data into this then it counts 2 after that it works fine but in very first time it counts 1 despite the field has null.

int notesCount=0;

    (SELECT COUNT("+Constants.NOTES+") FROM (select distinct "+Constants.NOTES+" from "+ Constants.TABLE_NAME_CONTACTS+ ")) AS notesCount

i need to count how many notes added and want to print it for my report section — Manoj Yadav, Nov 09 '15 at 07:52
Possible duplicate of [Select count(\*) from multiple tables](http://stackoverflow.com/questions/606234/select-count-from-multiple-tables) — OneCricketeer, Nov 09 '15 at 13:48
i have inserted the value in notes column and i am used to check if <> null then it will count no. of notes, thats the problem that i am facing. and every things count except notes. — Manoj Yadav, Nov 10 '15 at 06:25
I got solution, here for notes add new query (SELECT COUNT("+Constants.NOTES+") FROM (select distinct "+Constants.NOTES+" from "+ Constants.TABLE_NAME_CONTACTS+ ")) AS notesCount)) but one issues there that is notes doesnt have any value and it count 1 in very first time — Manoj Yadav, Nov 14 '15 at 06:55

score 0 · Answer 1 · answered Nov 09 '15 at 07:37

0

These are actually two separate queries. Execute them one by one.

answered Nov 09 '15 at 07:37

zmbq

38,013
14
101
171

i have done using only one query so here why i use distinct query – Manoj Yadav Nov 09 '15 at 07:51

getting count one in very first time but the field is null when using count query

1 Answers1