te.org [mailto:sqlite-users-
> bounces at mailinglists.sqlite.org] On Behalf Of Igor Tandetnik
> Sent: Friday, February 19, 2016 11:04 PM
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Process duplicate field values
>
> On 2/19/2016 1:00 AM, admin at shuling.ne
On 2/19/2016 8:16 PM, admin at shuling.net wrote:
> No. Originally I think since task 2 and 3 are operations performed on the
> same set of records, maybe they can be merged to improved the performance
> though one is get and another is set.
Ah. Perhaps you are looking for sqlite3_changes() API fu
y, February 19, 2016 11:04 PM
> > To: sqlite-users at mailinglists.sqlite.org
> > Subject: Re: [sqlite] Process duplicate field values
> >
> > On 2/19/2016 1:00 AM, admin at shuling.net wrote:
> > > 1. For all conflict records, get the total count of distinct F1
> v
half Of R Smith
> Sent: Friday, February 19, 2016 5:41 PM
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Process duplicate field values
>
>
>
> On 2016/02/19 8:00 AM, admin at shuling.net wrote:
> > Hi,
> >
> >
> >
> > I cre
Hi
Sorry for the confusion.
The distinct values for F1 is only 1, 2 and 3, so the distinct value count is
3. However, there are totally 6 records that have duplicate F1 values. The task
2 is to calculate the total count of conflict records so it is 6.
Hope that explain the issue clearly.
Than
Sent: Friday, February 19, 2016 3:23 PM
> To: 'SQLite mailing list'
> Subject: Re: [sqlite] Process duplicate field values
> Sensitivity: Confidential
>
> Basic idea, no testing
>
> The core query is
>
> Select F1 as key,count() as count from MyTable group by
Hi,
I create a table as follows:
CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER);
Then add the following records:
INSERT INTO MyTable (F1, F2) Values (1, 2);
INSERT INTO MyTable (F1, F2) Values (1, 3);
INSERT INTO MyTable (F1, F2) Values (2, 4);
INSERT INTO MyTable (F1, F2) Values (2,
On 2016/02/19 8:00 AM, admin at shuling.net wrote:
> Hi,
>
>
>
> I create a table as follows:
>
>
>
> CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER);
>
>
>
> Then add the following records:
>
>
>
> INSERT INTO MyTable (F1, F2) Values (1, 2);
>
> INSERT INTO MyTable (F1, F2) Values (1,
On 2/19/2016 1:00 AM, admin at shuling.net wrote:
> 1. For all conflict records, get the total count of distinct F1 values.
> In the above sample, record 1, 2, 3, 4, 5, 6 are conflict records, but the
> distinct values are only 1, 2, 3 so the total count should be 3.
> 2. Get the total co
> Le 19 f?vr. 2016 ? 07:00, admin at shuling.net a ?crit :
>
>1. For all conflict records, get the total count of distinct F1 values.
> In the above sample, record 1, 2, 3, 4, 5, 6 are conflict records, but the
> distinct values are only 1, 2, 3 so the total count should be 3.
>2. Get the
uar 2016 07:01
An: sqlite-users at mailinglists.sqlite.org
Betreff: [sqlite] Process duplicate field values
Wichtigkeit: Hoch
Vertraulichkeit: Vertraulich
Hi,
I create a table as follows:
CREATE TABLE MyTable (F1 INTEGER, F2 INTEGER);
Then add the following records:
INSERT INTO MyTable
11 matches
Mail list logo