On 14/09/2016 9:59 PM, R Smith wrote:
I think this is answered, but since you are a bit new to SQLite, and
to be somewhat more informant...
SQLite is certainly a different experience to the enterprise class data
bases that I'm used to but I like it. I'm still getting used to the duck
typing
I think this is answered, but since you are a bit new to SQLite, and to
be somewhat more informant...
On 2016/09/14 3:19 PM, David Crayford wrote:
Of course. How do I do something similar to DB2 decimal() function
which will add trailing zeros to precision? I tried round(col,6) but
it knocked
On 14/09/2016 9:23 PM, Clemens Ladisch wrote:
David Crayford wrote:
How do I do something similar to DB2 decimal() function which will add trailing
zeros to precision?
You could use the standard SQL CAST() to convert the value back into a number,
by why not simply sort by the original number
David Crayford wrote:
> How do I do something similar to DB2 decimal() function which will add
> trailing zeros to precision?
You could use the standard SQL CAST() to convert the value back into a number,
by why not simply sort by the original number to begin with?
ORDER BY max(cpu1)
Regards
Of course. How do I do something similar to DB2 decimal() function which
will add trailing zeros to precision? I tried round(col,6) but it
knocked off the trailing zero like 12.12345.
On 14/09/2016 9:10 PM, Clemens Ladisch wrote:
David Crayford wrote:
9.733366
595.509361
29.117646
28.607606
On Wed, Sep 14, 2016 at 3:10 PM, Clemens Ladisch wrote:
> The sort order of these strings looks correct.
>
As hinted by Clemens, you're sorting text values, not reals. See below. --DD
C:\Users\ddevienne>sqlite3
SQLite version 3.10.2 2016-01-20 15:27:19
Enter ".help" for usage hints.
Connected t
On 14 Sep 2016, at 2:10pm, Clemens Ladisch wrote:
> The sort order of these strings looks correct.
Heh. Heh heh.
Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite
David Crayford wrote:
> 9.733366
> 595.509361
> 29.117646
> 28.607606
> 14.684294
The sort order of these strings looks correct.
Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/
Greetings,
I've just started using sqlite to (ironically) report on z/OS DB2 stats.
I've written a query where the results look a bit strange. I group by
the DB2 plan name and order by the maximum
CPU time. The sort order looks incorrect as you can see in the report
below. I'm certainly not di
9 matches
Mail list logo