TechplexEngineer
10/9/2015 - 1:01 PM
Create a histogram of UUIDs by their first character
Create a histogram of UUIDs by their first character
SELECT LEFT(`assetuuid`,1) as `ST`, count(*) as `CNT`
FROM `tex`
GROUP BY `ST`Create a histogram of UUIDs by their first character
SELECT LEFT(`assetuuid`,1) as `ST`, count(*) as `CNT`
FROM `tex`
GROUP BY `ST`