On 2014/10/14 16:19, Clemens Ladisch wrote:
RSmith wrote:
On 2014/10/14 13:09, Clemens Ladisch wrote:
SELECT CASE WHEN previd = 0 THEN '--' || char(10) END, *
FROM (SELECT ...);
This solution from Clemens will work perfectly, and depending on the
kind of OS you use and output meth
RSmith wrote:
> On 2014/10/14 13:09, Clemens Ladisch wrote:
>> SELECT CASE WHEN previd = 0 THEN '--' || char(10) END, *
>> FROM (SELECT ...);
>
> This solution from Clemens will work perfectly, and depending on the
> kind of OS you use and output method it might even work to add
> somet
On 2014/10/14 13:09, Clemens Ladisch wrote:
Paul Sanderson wrote:
SELECT CASE WHEN previd = 0 THEN '--' || char(10) END, *
FROM (SELECT ...);
This solution from Clemens will work perfectly, and depending on the kind of OS you use and output method it might even work to add
someth
Thanks Clemens
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC
processing
Paul Sanderson wrote:
> 1|0|texas
> 2|1|new york
> 3|2|washington
> 4|0|tampa
> 5|0|atlanta
> 6|5|charleston
>
> I'd like to add a break between groups in the results so it looks somethng
> like
>
> 1|0|texas
> 2|1|new york
> 3|2|washington
>
> 4|0|tampa
>
> 5|0|atlanta
> 6|5|charleston
SELECT C
Another morning another question
I have a query that performs a recursive query and outputs a varying
number of rows using group by
sqlite> with recursive path as (select id, previd, location from
cities union all select cities.id, cities.previd, cities.location from
path join cities on (path.pre
6 matches
Mail list logo
