SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table parent (id int, name varchar, max_version int); insert into parent values (1, 'first', 3), (2, 'second', 1); create table children (id int, parent_id int, version int, data varchar); insert into children values (1, 1, 1, 'data1'), (2, 1, 2, 'data2'), (3, 1, 3, 'data3'), (4, 2, 1, 'data4'); SELECT p.name, c.data FROM parent p JOIN children c on p.id=c.parent_id WHERE p.max_version = c.version;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear