Logo Home    Page list

Births of children as facts #birth #child #events

The birth of a child is a major life event for a person so I thought it would be worth adding to the stream of events query for a person. This query is designed to be pasted into the AllFacts4Person5.sql file - it follows the same columnar format - or it can be run on its own. For some unknown reason, it was unnecessary to mess with INDEXED BY and NOT INDEXED clauses to get fast results so this query should run on all flavours of SQLite3.

PersonsBegatChildren.sql

Screen shot from SQLite Developer - note the filter drop-down list box on the Count column.
SQLiteDeveloperSQLeditorPersonsBegatChildren.png
www.000webhost.com