How to run query to keep maximum 3 rows with the same name, MySQL

How to run query to keep maximum 3 rows with the same name

Language: Layout:


absolute service time: 0,37 sec

edit mode | history | discussion

  
id
item_name
price_good

1
1
Row 1
1

2
2
Row 1
1

3
3
Row 1
0

4
4
Row 1
0

5
5
Row 1
1

6
6
Row 1
0

7
7
Row 1
0

8
8
Row 1
0

9
9
Row 2
0

10
10
Row 2
1

λ

                                      .NET NoSQL database for rapid development