Posted in sqlite
87
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
2
This Month
27
This Year
87

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


Me