不对,是从sipa05写到sipfa21
时间: 2023-11-09 12:08:35 浏览: 21
好的,那么以下是从 sipfa05 到 sipfa21 的 SQL 语句:
```
select count(*) from sipfa05;
select count(*) from sipfa05_20230609;
select count(*) from sipfa06;
select count(*) from sipfa06_20230609;
select count(*) from sipfa07;
select count(*) from sipfa07_20230609;
select count(*) from sipfa08;
select count(*) from sipfa08_20230609;
select count(*) from sipfa09;
select count(*) from sipfa09_20230609;
select count(*) from sipfa10;
select count(*) from sipfa10_20230609;
select count(*) from sipfa11;
select count(*) from sipfa11_20230609;
select count(*) from sipfa12;
select count(*) from sipfa12_20230609;
select count(*) from sipfa13;
select count(*) from sipfa13_20230609;
select count(*) from sipfa14;
select count(*) from sipfa14_20230609;
select count(*) from sipfa15;
select count(*) from sipfa15_20230609;
select count(*) from sipfa16;
select count(*) from sipfa16_20230609;
select count(*) from sipfa17;
select count(*) from sipfa17_20230609;
select count(*) from sipfa18;
select count(*) from sipfa18_20230609;
select count(*) from sipfa19;
select count(*) from sipfa19_20230609;
select count(*) from sipfa20;
select count(*) from sipfa20_20230609;
select count(*) from sipfa21;
select count(*) from sipfa21_20230609;
```
以上语句依次查询了 sipfa05 到 sipfa21 表(包括表的分区)中的总行数,其中每个表名后面的 "_20230609" 表示该表的 2023 年 6 月 9 日的分区。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)