"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

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 Asking COUNT(*) AS FIELDCOUNT FROM RDB$RELATIONS R JOIN RDB$RELATION_FIELDS RF ON RF.RDB$RELATION_NAME = R.RDB$RELATION_NAME GROUP BY RELATION) Chapter 6. Data Manipulation

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 Asking 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 A trivial

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 Abfrage 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 Ein