Difference between revisions of "sqlite3 quick reference"

From thelinuxwiki
Jump to: navigation, search
(Created page with "==counting== '''count unique column entries''' sqlite3 dbfile "SELECT COUNT(DISTINCT ipaddress) FROM table;"")
 

Latest revision as of 13:58, 3 October 2017

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"