Posted in sqlite
4
2:02 am, November 11, 2021

count total results from distinct sqlite

a query to count the total items found on a distinct query

PHP

SELECT COUNT(DISTINCT suburb) FROM nz_postcodes;

View Statistics
This Week
26
This Month
145
This Year
0

No Items Found.

Add Comment
Type in a Nick Name here
 
Search Code
Search Code by entering your search text above.
Welcome

This is my test area for webdev. I keep a collection of code snippits here, mostly for my reference. Also if i find a good site, i usually add it here.

Join me on Substack if you want me to send you a collection of the things i have done or found or read for the week. Or follow me on twitter if you prefer, i dont post much but i probably should!

❤👩‍💻🕹

Random Quote
The happiest People don't have the best of everything, they just make the best of everything.
Unknown