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
0
This Month
0
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
You drown not by falling in the river, but by staying submerged.
Unknown