Answer the question
In order to leave comments, you need to log in
How to count the number of rows with the same id in the database?
Hello
In the database there are rows with the same id, for example, the same customer ordered several products. How to count the number of customers who ordered more than 3 products? SQL language
+----+-------+--------+
| id | name | phone |
+----+-------+--------+
| 2 | name2 | phone1 |
| 2 | name2 | phone2 |
+----+-------+--------+
Answer the question
In order to leave comments, you need to log in
Exact task - you need to display the names of customers who had more than 3 orders.
Database in SQLServer
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question