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 made easy
On 14 October 2014 12:09, Clemens Ladisch <clem...@ladisch.de> wrote: > 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 CASE WHEN previd = 0 THEN '--------------' || char(10) END, * > FROM (SELECT ...); > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
