sqlite3 quick reference

From thelinuxwiki
Revision as of 13:58, 3 October 2017 by Nighthawk (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

counting

count unique column entries

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