常用核心数据库查询sql

一、查询账户信息

-- 查询数据量

select base_acct_no,count(1) num from mb_tran_hist group by base_acct_no ORDER BY num desc;


select base_acct_no,count(1) num from mb_tran_hist group by base_acct_no ORDER BY num desc;


select base_acct_no,count(1) num from mb_tran_hist group by base_acct_no ORDER BY num desc;


select base_acct_no,count(1) num from mb_tran_hist group by base_acct_no ORDER_BY num desc;

常用核心数据库查询sql

原文地址：https://www.cnblogs.com/huazheng/p/13359003.html