SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Country ( id INT NOT NULL PRIMARY KEY, project_name VARCHAR(255), postal_code INT NOT NULL ); INSERT INTO Country(id, postal_code, project_name) VALUES (1, 4000,'Athens'); INSERT INTO Country(id, postal_code, project_name) VALUES (2, 2008,'Beijing'); INSERT INTO Country(id, postal_code, project_name) VALUES (3, 3012,'London'); INSERT INTO Country(id, postal_code, project_name) VALUES (4, 4000,'UK'); INSERT INTO Country(id, postal_code, project_name) VALUES (5, 4000,'Egypt'); INSERT INTO Country(id, postal_code, project_name) VALUES (6, 4000,'Japan'); select * from (select postal_code, project_name, row_number () over (partition by postal_code order by project_name) as row_number from country order by postal_code) as postal where row_number > 1;