How to display the number of unique records in mysql?

Question

MySQL

Good afternoon.
There is a table with goods. Each has an article, name, etc.
The task is: to count the number of records in the table, grouped by article and with a unique name.
That is, if we have 2 records in the table, but they have the same name, we need to display 1 in COUNT.
To begin with, I simply made a query in order to get the number of records (not unique)

SELECT artikul, COUNT(*) AS CNT FROM items GROUP BY articul

Further, to uniqueize the records, I added DISTINCT, but this did not give the expected result, the records are not unique by name

SELECT artikul, COUNT(DISTINCT name) AS CNT FROM items GROUP BY articul

Answer 1

Now you are asking for the number of unique names for each article.
If you want to get the number of records by unique pairs (article, name), then you need to group by both fields.