SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE ForgeRock (id varchar(13), description varchar(57)) ; CREATE TABLE Identity (id varchar(12)); insert into Identity (id) values ('1'), ('2'); INSERT INTO ForgeRock (id, description) VALUES ('1', 'Platform for building enterprise provisioning solutions'), ('1', 'Full-featured access management'), ('2', 'Robust LDAP server for Java 1'), ('2', 'Robust LDAP server for Java 2'), ('2', 'Robust LDAP server for Java 3') ; commit; select row_number() over (f.id) n, f.id from Identity i inner join ForgeRock f where i.id = f.id;