How do I preview the first rows of a CSV file with SQL?

SELECT * FROM data LIMIT 10;

The fastest way to sanity-check a file you just loaded is `SELECT * FROM data LIMIT 10`. `LIMIT` caps the number of rows returned so you're not scrolling through the whole file just to see what columns and types you're working with. This is usually the very first query to run on any new dataset.

A table named data with columns: order_id (integer), customer (text), country (text), category (text), quantity (integer), unit_price (real), order_date (text, YYYY-MM-DD).