Aggregate: COUNT
.mode batch
.import --csv examples/iris.csv iris
SELECT COUNT(*) FROM iris;
SELECT COUNT(*) FROM iris WHERE Species == 'Iris-virginica';
$ sqlite3 < examples/count-iris.sql
150
50
Press ← or → to navigate between chapters
Press S or / to search in the book
Press ? to show this help
Press Esc to hide this help
.mode batch
.import --csv examples/iris.csv iris
SELECT COUNT(*) FROM iris;
SELECT COUNT(*) FROM iris WHERE Species == 'Iris-virginica';
$ sqlite3 < examples/count-iris.sql
150
50