Can this be done in SQLite SQL? ID Value --------------- 1 A 1 B 1 C 1 D 1 E 2 A 2 B 2 C 2 D 2 E 2 F
Delete rows to leave x rows per ID, say 3 rows, so we get: ID Value --------------- 1 C 1 D 1 E 2 D 2 E 2 F If there were less than 3 rows for a group then that group should be ignored, so now rows should be deleted from that group. RBS _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users