LIMIT the number of rows
.import --csv examples/iris.csv iris
SELECT * FROM iris LIMIT 3;
sqlite3 < examples/limit-iris.sql
1|5.1|3.5|1.4|0.2|Iris-setosa
2|4.9|3|1.4|0.2|Iris-setosa
3|4.7|3.2|1.3|0.2|Iris-setosa
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
.import --csv examples/iris.csv iris
SELECT * FROM iris LIMIT 3;
sqlite3 < examples/limit-iris.sql
1|5.1|3.5|1.4|0.2|Iris-setosa
2|4.9|3|1.4|0.2|Iris-setosa
3|4.7|3.2|1.3|0.2|Iris-setosa