Keyboard shortcuts

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

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