Luuk wrote:
>sqlite> .mode column
>sqlite> .headers on
>sqlite> select 1 as X,date() as d union all select 2,date() union all
>select 3,datetime();
>X d
>-- --
>1 2018-12-25
>2 2018-12-25
>3 2018-12-25
The value is longer than the column
You can always turn your 100/count(ID) into a scalar expression (so that it is
only calculated once):
select ID,
(count(Quantity) over Win1) * (select 100.0/count(ID) from mytable) as
Percentile
from myTable
Window Win1 as (order by Quantity range between unbounded preceding and current
row);
Thank you, Dan. My eyes saw the underscore, but my brain did not process
it!
And many thanks to the SQLite development team for introducing this feature
and making it so efficient. I had the need to compute running sums and
averages in a query, and I have views which use regular queries and
On 24-12-2018 21:25, Shawn Wagner wrote:
Using '.mode column" in conjunction with ".headers on" you're already using
makes it a lot more obvious.
like this:
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open
Sadly by the time you get here it will be over for another year. Still
seasons greetings from the UK.
On Tue, 25 Dec 2018 at 13:45, Richard Hipp wrote:
> On 12/25/18, Mike King wrote:
> > It’s
> > Christmas Day so surely you deserve a mince pie and a fine single malt :)
>
> Sounds great! Send
On 12/25/18, Mike King wrote:
> It’s
> Christmas Day so surely you deserve a mince pie and a fine single malt :)
Sounds great! Send me your address and I'll be right over! ;-)
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
Surely I speak for all of when I say I hope you have a fantastic Christmas
Richard and thanks for everything you do. Do you ever stop though? It’s
Christmas Day so surely you deserve a mince pie and a fine single malt :)
Cheers
On Tue, 25 Dec 2018 at 11:18, Richard Hipp wrote:
> Thanks. Fixed
Thanks. Fixed here: https://www.sqlite.org/src/info/a1f50d57ce76f6c0
On 12/25/18, gwenn wrote:
> Hi,
> There is a typo here:
> https://sqlite.org/session/sqlite3changeset_op.html
>> If pbIncorrect is not NULL, then *pbIndirect is set to true
> Should be pbIndirect instead of pbIncorrect.
>
Hi,
There is a typo here:
https://sqlite.org/session/sqlite3changeset_op.html
> If pbIncorrect is not NULL, then *pbIndirect is set to true
Should be pbIndirect instead of pbIncorrect.
Regards.
___
sqlite-users mailing list
9 matches
Mail list logo
