CODEWITHSUNDEEP
iphoneiosobjective-ccocoa-touch
user1525369
user1525369

Reputation:

Get total number of filled row in table in SQLite

My Question is Similar to MySQL, count the number of "filled" fields in a table

But i can not got my proper solution. How is it possible in Sqlite?

I Know about get using for loop. but i want to get by query.

Please help me on this issue.

Thanks in Advance.

Upvotes: 1

Views: 325

Answers (1)

Ken
Ken

Reputation: 1985

A query like this will work:

SELECT COUNT(*) from raw where rawData <> '' AND rawData IS NOT NULL

This assumes there is a table called "raw" and the column you're checking against is "rawData"

Upvotes: 1

Related Questions