"Table Name", (SELECT MAX(I.RDB$STATISTICS) || ' (' || COUNT(*) || ')' FROM RDB$RELATION_FIELDS RF WHERE RF.RDB$RELATION_NAME = 121 Руководство по языку SQL R.RDB$RELATION_NAME ) AS "Max. IndexSel RDB$RELATION_NAME TABLE_NAME, SUM( (SELECT COUNT(*) FROM RDB$RELATION_FIELDS RF WHERE 123 Руководство по языку SQL RF.RDB$RELATION_NAME = R.RDB$RELATION_NAME ) ) AS IND_X_FIELDS FROM RDB$RELATIONS AS FIELDCOUNT 129 Руководство по языку SQL FROM RDB$RELATIONS R JOIN RDB$RELATION_FIELDS RF ON RF.RDB$RELATION_NAME = R.RDB$RELATION_NAME GROUP BY RELATION) GROUP BY FIELDCOUNT Тривиальный пример

relation, COUNT(*) AS fieldcount FROM rdb$relations r JOIN rdb$relation_fields rf ON rf.rdb$relation_name = r.rdb$relation_name GROUP BY relation) GROUP BY fieldcount COUNT(*) AS FIELDCOUNT FROM RDB$RELATIONS R JOIN RDB$RELATION_FIELDS RF ON RF.RDB$RELATION_NAME = R.RDB$RELATION_NAME GROUP BY RELATION) GROUP BY FIELDCOUNT