View source for sqlite3 quick reference

← sqlite3 quick reference

Jump to: navigation, search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page:

==counting==
'''count unique column entries'''
 sqlite3 dbfile "SELECT COUNT(DISTINCT ipaddress) FROM table;"

Return to sqlite3 quick reference.

Retrieved from "http://www.thelinuxwiki.com/index.php/sqlite3_quick_reference"

Navigation menu