SQLite union all operator with example. In sqlite union all operator is used to combine and return multiple select statement result sets including duplicate values.