Re: [sqlite] Grouping and grabbing one item

no...@null.net wrote: > On Wed Oct 18, 2017 at 07:57:24PM +0200, Darko Volaric wrote: >> select (SELECT ed from Tasks where task = 'QUOTE' and Pid = 1), >> max(ed),target, sum(amt) from Tasks where Pid=1 group by target >> HAVING amt > 0; > > When I first read that query I wondered if putting a

Re: [sqlite] Grouping and grabbing one item

mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of jose isaias cabrera >Sent: Wednesday, 18 October, 2017 16:39 >To: SQLite mailing list >Subject: Re: [sqlite] Grouping and grabbing one item > > >Ok, I missed a condition. Imagine this set of data, > > &

Re: [sqlite] Grouping and grabbing one item

Thanks. -Original Message- From: no...@null.net Sent: Wednesday, October 18, 2017 3:17 PM To: SQLite mailing list Subject: Re: [sqlite] Grouping and grabbing one item On Wed Oct 18, 2017 at 07:57:24PM +0200, Darko Volaric wrote: select (SELECT ed from Tasks where task = 'QUOTE' and

Re: [sqlite] Grouping and grabbing one item

This last one does appear faster... Thanks. -Original Message- From: no...@null.net Sent: Wednesday, October 18, 2017 3:17 PM To: SQLite mailing list Subject: Re: [sqlite] Grouping and grabbing one item On Wed Oct 18, 2017 at 07:57:24PM +0200, Darko Volaric wrote: select

Re: [sqlite] Grouping and grabbing one item

On Wed Oct 18, 2017 at 07:57:24PM +0200, Darko Volaric wrote: > select (SELECT ed from Tasks where task = 'QUOTE' and Pid = 1), > max(ed),target, sum(amt) from Tasks where Pid=1 group by target > HAVING amt > 0; When I first read that query I wondered if putting a query inside a select

Re: [sqlite] Grouping and grabbing one item

Thanks, I didn't know that was possible. -Original Message- From: Paul Sanderson Sent: Wednesday, October 18, 2017 2:10 PM To: SQLite mailing list Subject: Re: [sqlite] Grouping and grabbing one item How about select (SELECT ed from Tasks where task = 'QUOTE' and Pid = 1), max(ed

Re: [sqlite] Grouping and grabbing one item

ober 18, 2017 1:57 PM > To: SQLite mailing list > Subject: Re: [sqlite] Grouping and grabbing one item > > > select (SELECT ed from Tasks where task = 'QUOTE' and Pid = 1), > max(ed),target, sum(amt) from Tasks where Pid=1 group by target HAVING amt > > 0; > > >

Re: [sqlite] Grouping and grabbing one item

How about select (SELECT ed from Tasks where task = 'QUOTE' and Pid = 1), max(ed),target, sum(amt) from Tasks where Pid=1 group by target HAVING amt > 0; 2017-09-27|2017-10-01|es-ES|170.0 2017-09-27|2017-10-01|fr-FR|185.0 2017-09-27|2017-10-01|it-IT|200.0 Paul www.sandersonforensics.com

Re: [sqlite] Grouping and grabbing one item

So simple! Thanks, Darko. -Original Message- From: Darko Volaric Sent: Wednesday, October 18, 2017 1:57 PM To: SQLite mailing list Subject: Re: [sqlite] Grouping and grabbing one item select (SELECT ed from Tasks where task = 'QUOTE' and Pid = 1), max(ed),target, sum(amt) from

Re: [sqlite] Grouping and grabbing one item

select (SELECT ed from Tasks where task = 'QUOTE' and Pid = 1), max(ed),target, sum(amt) from Tasks where Pid=1 group by target HAVING amt > 0; > On Oct 18, 2017, at 7:23 PM, jose isaias cabrera > wrote: > > > CREATE TABLE Tasks ( > id INTEGER PRIMARY KEY, > Pid

[sqlite] Grouping and grabbing one item

CREATE TABLE Tasks ( id INTEGER PRIMARY KEY, Pid INTEGER, bd TEXT, ed TEXT, task TEXT, target TEXT, amt REAL ); INSERT INTO Tasks (Pid,bd,ed,task,target,amt) VALUES (1,'2017-09-27','2017-09-27','QUOTE','es-ES fr-FR it-IT',0); INSERT INTO Tasks (Pid,bd,ed,task,target,amt) VALUES