I'm no expert, but I'd do it with:
SELECT COUNT(*) AS count FROM ratingsTable GROUP BY mtId ORDER BY count
DESC LIMIT 1;
:-David Burström
On 01/25/2011 03:49 PM, Puneet Kishor wrote:
>
> Ian Hardingham wrote:
>> Hey guys.
>>
>> I have the following table:
>
Dan, Richard, Igor,
thanks for your input, and yes, it seems as if the gamble is no longer
safe. Hopefully I'm the only one that has run into this side effect ;)
:-David
On 01/17/2011 04:57 PM, Igor Tandetnik wrote:
> David Burström wrote:
>> SELECT starttime, endtime from e
> Senior Scientist
> Advanced Analytics Directorate
> Northrop Grumman Information Systems
>
>
>
>
> From: sqlite-users-boun...@sqlite.org on behalf of David Burström
> Sent: Mon 1/17/2011 6:47 AM
> To: sqlite-users@sqlite.org
> Subject:
Hello all!
I stumbled across this strange bug during Android development on 2.2.1
late last night. Please run the following snippet in SQLite 3.7.2 and
3.6.22 to compare the differences. The comments shows what alterations
you can make to make the query return the expected result.
:-David
4 matches
Mail list logo