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
test 2
Conditional SQL select
Test for MySQL "serializable" transaction, part 1
name
user data by unspecific date, according to param "last entry, last but one, last but two, etc."
order_history
Srinivas
nw
sree..
ze