sqlite3 quick reference

From thelinuxwiki
Jump to: navigation, search

counting

count unique column entries

sqlite3 dbfile "SELECT COUNT(DISTINCT ipaddress) FROM table;"