Hello All,
With the select statement below and my test data of 43 files, I expected the
following results
22 'Less than 1MB'
4 'Less than 5MB'
7 'Less than 10MB'
4 'Less than 15MB'
6 'Less than 20MB'
Instead I get
16 'Less than 1MB'
18 'Less than 5MB'
9 'Larger than 25GB'
I have been pulling
On 4/11/17, Ron Barnes wrote:
>
> I have been pulling my hair out trying to figure out where I went south. If
> someone could, would you point out my mistake, please?
What does this query show:
SELECT DISTINCT typeof(VI_File_Len) FROM Volume_Information;
And in particular, does it show that
ss Than 25 GB'
ELSE 'Larger Than 25GB' END) AS category
FROM Volume_Information) derivedtbl_1
GROUP BY category
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Ron Barnes
Sent: Tuesday, April 11, 2017 9:15 PM
To:
On 12 Apr 2017, at 2:27am, Ron Barnes wrote:
> I needed to add the Cast parameter.
Assuming you are actually storing integers, it might be better if you declared
that column as integer in the first place. Then you wouldn’t need the CAST.
However, well done for figuring it out, possibly with
-boun...@mailinglists.sqlite.org] On
Behalf Of Simon Slavin
Sent: Tuesday, April 11, 2017 9:31 PM
To: SQLite mailing list
Subject: Re: [sqlite] Select Statement returning incorrect information
On 12 Apr 2017, at 2:27am, Ron Barnes wrote:
> I needed to add the Cast parameter.
Assuming you are
5 matches
Mail list logo