Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
How to run query to keep maximum 3 rows with the same name
drop table if exists ss_remote_inventories; CREATE TABLE ss_remote_inventories (`id` int, `item_name` varchar(5), `price_good` int) ; INSERT INTO ss_remote_inventories (`id`, `item_name`, `price_good`) VALUES (1, 'Row 1', 1), (2, 'Row 1', 1), (3, 'Row 1', 0), (4, 'Row 1', 0), (5, 'Row 1', 1), (6, 'Row 1', 1), (7, 'Row 1', 1), (8, 'Row 1', 1), (9, 'Row 2', 0), (10, 'Row 2', 1) ; update ss_remote_inventories t set t.price_good = 0 where id in ( select id from( select a.* from ss_remote_inventories a where a.price_good = 1 and ( select count(*) from ss_remote_inventories b where a.item_name = b.item_name and b.price_good = 1 and a.id > b.id ) > 2 ) t1 ); select * from ss_remote_inventories
run
|
edit
|
history
|
help
0
gustavoclientes
dbms queryn2
ITM_14210069
Rakibul Haque
Patel
pt.stackoverflow.com/questions/170610
DateAdd y AddDate
Simon_Test1
Demo: procedure and delimiter
admin@pkms99.info