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;"
Retrieved from "http://www.thelinuxwiki.com/index.php?title=sqlite3_quick_reference&oldid=1148"