... been refining this based on several examples and the following solution seems to be the most stable:
ol {
list-style-type: none;
counter-reset: myCounter;
display: table;
margin ...
... an alias to the field:
-- Note the alias for the field
SELECT COUNT( DISTINCT `my_field`) AS myCount FROM my_table;
Method #2: Count from results (my preference):
-- Note the alias for the ...
... but just the count is extracted:
-- DataSet2:
SELECT
COUNT(*) AS myCount
FROM
PersonsTable
WHERE
(Reference = @GivenRef OR @GivenRef ='')
AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.