)
SELECT * FROM latestByBranch
ORDER BY ts DESC
;
</pre></nowiki>
<h2>Recursion Example</h2>

See also: [http://www.sqlite.org/draft/lang_with.html]
See also: [https://www.sqlite.org/lang_with.html]

The following is adapted from a sqlite mailing list post by Petite Abeille on 20140203, not directly applicable to fossil but which is an interesting example nonetheless and which can certainly be used as a model for generating fossil-related data:

<nowiki><pre>
with
DataSet(node,parent)
as