Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme 

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

Language: Editor: 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