If you are using contentProvider then you have to do it like count(*) AS count. If you use cursor.getCount(), that would not be as efficient as the above approach. With cursor.getCount() you are fetching all the records just to get counts. The entire code should look like following – Cursor countCursor = getContentResolver().query(CONTENT_URI, new String[] … Read more
By default, count() ignores limit() and counts the results in the entire query. So when you for example do this, var a = db.collection.find(…).limit(10); running a.count() will give you the total count of your query.
May be with: SELECT count(*) FROM `table` where created_at>=’2011-03-17 06:42:10′ and created_at<=’2011-03-17 07:42:50′; or use between: SELECT count(*) FROM `table` where created_at between ‘2011-03-17 06:42:10’ and ‘2011-03-17 07:42:50’; You can change the datetime as per your need. May be use curdate() or now() to get the desired dates.
select t.Topic, t.Title, count(distinct s.starID) as StarCount, count(distinct m.User) as UserCount, count(distinct m.messageID) as MessageCount from Topics t left join Messages m ON m.Topic = t.Topic left join Stars_Given s ON s.Topic = t.Topic group by t.Topic, t.Title Sql Fiddle Or, you can perform the aggregation in sub-queries, which will likely be more efficient if … Read more
You don’t seem interested in the actual count so give this a try: SELECT 1 FROM table WHERE fk = 1 LIMIT 5000, 1 If a row is returned, you have 5000 and more records. I presume the fk column is indexed.
Fix the LEFT JOIN This should work: SELECT o.name AS organisation_name, count(e.id) AS total_used FROM organisations o LEFT JOIN exam_items e ON e.organisation_id = o.id AND e.item_template_id = #{sanitize(item_template_id)} AND e.used GROUP BY o.name ORDER BY o.name; You had a LEFT [OUTER] JOIN but the later WHERE conditions made it act like a plain [INNER] … Read more
SELECT a.code, COALESCE(b.totalNotXorD, 0 ) totalNotXorD, COALESCE(c.totalXorD, 0 ) totalXorD, FROM (SELECT DISTINCT Code FROM tableName) a LEFT JOIN ( select code, count(*) totalNotXorD from table where status not in(‘X’,’D’) group by code ) b ON a.code = b.code LEFT JOIN ( select code, count(*) totalXorD from table where status in(‘X’,’D’) and cancel_date >= ‘2012-02-01’ … Read more
If you have some given list, and want to iterate over its items and indices, you can use enumerate(): for index, item in enumerate(my_list): print index, item If you only need the indices, you can use range(): for i in range(len(my_list)): print i
SELECT IGrp, COUNT(CASE WHEN Value1 > 1 THEN 1 ELSE NULL END) AS V1High, COUNT(CASE WHEN Value2 > 1 THEN 1 ELSE NULL END) AS V2High FROM Tbl GROUP BY IGrp