Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
test
DROP TABLE IF EXISTS tabela; create table tabela (item_1 varchar(30), item_2 varchar(30),grupo varchar(30)); insert into tabela (item_1, item_2, grupo) values ('item a','item k','group x'); insert into tabela (item_1, item_2, grupo) values ('item b','item l','group y'); insert into tabela (item_1, item_2, grupo) values ('item c','item a','group y'); insert into tabela (item_1, item_2, grupo) values ('item d','item j','group x'); insert into tabela (item_1, item_2, grupo) values ('item e','item m','group z'); SELECT MAX(item_1), item_2, grupo FROM tabela GROUP by grupo
run
|
edit
|
history
|
help
0
cus
ITM_14210069
Newspaper Site
Sql
dbms queryn2
ze
act5
teste
Get the value based on row before
GROUP_CONCAT Mysql