问题描述
我在Oracle中有一组表，我想确定包含最大行数的表.
I have a set of tables in Oracle and I would like to identify the table that contains the maximum number of rows.
因此，如果我希望能够识别表B，那么A有200行，B有345行，C有120行.
So if, A has 200 rows, B has 345 rows and C has 120 rows I want to be able to identify table B.
是否可以运行一个简单的查询来实现这一目标?
Is there a simple query I can run to achieve this?
有100多个表，所以我正在寻找通用的东西.
There are 100 + tables so I am looking for something generic.
推荐答案
鉴于您说您正在使用Oracle，我只会查询元数据.
Given that you said you were using Oracle I would just query the meta-data.
select table_name, max(num_rows) from all_tables where table_name in ('A', 'B', 'C');
刚刚看到了您的修改.只需运行不带where子句的上述内容，它将返回数据库中最大的表.唯一的问题可能是您可能会得到SYS $表或其他内容.或者，如果您只是为了自己的知识而这样做，
Just saw your edit. Just run the above without the where clause and it will return the largest table in the database. Only problem may be that you might get a SYS$ table or something. Alternately if you are just doing this for your own knowledge just do
select table_name, num_rows from all_tables order by num_rows;
您将看到最大的东西.
这篇关于在Oracle中标识具有最大行数的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！