Hello
I tried a few things, but I still can't find how to do this: The
Companies table contains one row for each company; each row has a Code
field that indicates the type of activity this company is into.
I'd like to count how many companies belong to each activity, and
display the top t
Hi,
It sounds like you want a GROUP BY clause, e.g.,
SELECT code, COUNT(code) AS code_count FROM companies GROUP BY code ORDER BY
code_count DESC;
Regards,
Eugene Wee
On Sun, Nov 23, 2008 at 4:16 PM, Gilles Ganault <[EMAIL PROTECTED]>wrote:
> Hello
>
>I tried a few things, but I still c
Oops, and as for top 10, a LIMIT 10 clause may suffice, e.g.,
SELECT code, COUNT(code) AS code_count FROM companies GROUP BY code ORDER BY
code_count DESC LIMIT 10;
However, if you wish to show the next 10, then the next 10, etc, then you
might consider the technique described in this wiki article
On Sun, 23 Nov 2008 16:40:11 +0800, "Eugene Wee"
<[EMAIL PROTECTED]> wrote:
>Oops, and as for top 10, a LIMIT 10 clause may suffice, e.g.,
>SELECT code, COUNT(code) AS code_count FROM companies GROUP BY code ORDER BY
>code_count DESC LIMIT 10;
>
>However, if you wish to show the next 10, then the n
* Brad House:
> When you said breaking compatibility with 2.4, you meant
> NPTL vs LinuxThreads, right?
My thought as well. There are still some architectures which do not
support NPTL, even with 2.6 kernels (hppa comes to my mind). But lack
of NPTL support causes pain in other areas, too, so i
>> When you said breaking compatibility with 2.4, you meant
>> NPTL vs LinuxThreads, right?
>
> My thought as well. There are still some architectures which do not
> support NPTL, even with 2.6 kernels (hppa comes to my mind). But lack
> of NPTL support causes pain in other areas, too, so it's p
Having been bitten by my misunderstanding of how sqlite uses indices, I would
like to make a request for a feature enhancment.
Currently, explain query plan lists the index being used with each table.
It would be very convenient if it would also list the columns of that index
being used. Thus,
Hi SQLite,
I would like to monitor an sqlite file for changes over the boundary
of a process. The function sqlite3_update_hook appeared promising
however appears to only apply to changes made within the same process.
Since the file for SQLite is specified I could be able to monitor it
using g_file
On Sun, 23 Nov 2008 10:33:28 -0600, "Dan Saul"
<[EMAIL PROTECTED]> wrote in General Discussion of
SQLite Database :
>Hi SQLite,
>
>I would like to monitor an sqlite file for changes over the boundary
>of a process. The function sqlite3_update_hook appeared promising
>however appears to only apply
Hi
I'm new to SQLite and triggers. Is it possible to set a trigger so it
updates a field of a new record in a table to the same value as the
Autoincrement field.
i.e.
Field1, Integer Autoincrement
Field2, Integer
Field3, Text
Field4, Text
When the user enters text in Field3 & Field4, Field1
"blackbox" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I'm new to SQLite and triggers. Is it possible to set a trigger so it
> updates a field of a new record in a table to the same value as the
> Autoincrement field.
>
> i.e.
>
> Field1, Integer Autoincrement
> Field2, Integer
>
Hi,
I'm looking into using sqlite in combination with asp.
I am limited to using the old asp and NO .net, therefore i've been looking
arround how i can manage to get asp working with sqlite but all i seem to be
able to find are asp.net wrappers.
Does anybody has any advice on how to do this? o
Thank you Kees!
On 23-Nov-08, at 11:18 AM, Kees Nuyt wrote:
> On Sun, 23 Nov 2008 10:33:28 -0600, "Dan Saul"
> <[EMAIL PROTECTED]> wrote in General Discussion of
> SQLite Database :
>
>> Hi SQLite,
>>
>> I would like to monitor an sqlite file for changes over the boundary
>> of a process. The fun
Hi,
I tried to execute the test for sqlite-amalgamation-3.6.5 repository but
there are some test cases which getting hanged like
lock-4.3...
Expected: [1 {database is locked} {0 1 2 3 4 5}]
Got: [1 {database is locked} {}]
lock-5.1... Ok
lock-5.2..-
14 matches
Mail list logo