The bit-twiddling hacks page has a number of options. Of course, you could argue that iterating over all 32 possible bits is O(N) in that it’s the same cost every time 🙂 For simplicity, I’d consider the lookup-table-per-byte approach, or Brian Kernighan’s neat idea which iterates as many times as there are bits set, which … Read more
try this way select (select count() from XXX) as count, * from XXX;
You can do both in one query using the OVER clause on another COUNT select count(*) RecordsPerGroup, COUNT(*) OVER () AS TotalRecords from temptable group by column_1, column_2, column_3, column_4
Like this: // Changed the query – there’s no need for DISTINCT // and aliased the count as “num” $data = mysql_query(‘SELECT COUNT(`users_id`) AS num FROM `users_table`’) or die(mysql_error()); // A COUNT query will always return 1 row // (unless it fails, in which case we die above) // Use fetch_assoc for a nice associative … Read more
Just use Counter from collections: from collections import Counter A = [[x,y],[a,b],[c,f],[e,f],[a,b],[x,y]] new_A = map(tuple, A) #must convert to tuple because list is an unhashable type final_count = Counter(new_A) #final output: for i in set(A): print i, “=”, final_count(tuple(i))
I loaded a SQLfiddle here: http://sqlfiddle.com/#!2/5349a/1 However, in your sample data, you had two ID=5. I made it unique. Also my SQLFiddle data doesn’t match yours anymore since I changed some values to make sure it worked. Have fun with it 🙂 (This works looking at the largest ID value for the sequence) Try this: … Read more
Did you try this: @page { @bottom-right { content: counter(page) ” of ” counter(pages); } }
Use the update method of Counter. Example: from collections import Counter data=””‘\ ashwin programmer india amith programmer india”’ c = Counter() for line in data.splitlines(): c.update(line.split()) print(c) Output: Counter({‘india’: 2, ‘programmer’: 2, ‘amith’: 1, ‘ashwin’: 1})
Test case: CREATE TABLE tbl (date date, email text); INSERT INTO tbl VALUES (‘2012-01-01’, ‘[email protected]’) , (‘2012-01-01’, ‘[email protected]’) , (‘2012-01-01’, ‘[email protected]’) , (‘2012-01-02’, ‘[email protected]’) , (‘2012-01-02’, ‘[email protected]’) , (‘2012-01-03’, ‘[email protected]’) , (‘2012-01-04’, ‘[email protected]’) , (‘2012-01-05’, ‘[email protected]’) , (‘2012-01-05’, ‘[email protected]’) , (‘2012-01-06’, ‘[email protected]’) , (‘2012-01-06’, ‘[email protected]’) , (‘2012-01-06’, ‘[email protected]`’) ; Query – returns only days where … Read more