2 ms·
Here is an example of how I would pipe with headers to `tv`. sqlite3 :memory: -csv -header -cmd '.import taxi.csv taxi' 'SELECT passenger_count, COUNT(*), AVG(
by flusteredBias 4y ago
Here is an example of how I would pipe with headers to `tv`.
sqlite3 :memory: -csv -header -cmd '.import taxi.csv taxi' 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' | tv