09-07-2007 03:46 AM
select parent_node_id, count(child_node_id) children from child_assoc group by parent_node_id order by children desc limit 10;+—————-+———-+
| parent_node_id | children |
+—————-+———-+
| 26 | 5707 |
| 25 | 1068 |
| 16 | 176 |
| 4892 | 57 |
| 752 | 37 |
| 20 | 35 |
| 768 | 28 |
| 856 | 25 |
| 280 | 24 |
| 378 | 19 |
+—————-+———-+
10 rows in set (0.35 sec)09-11-2007 05:01 AM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.