常用核心数据库查询sql [数据库教程]

database

一、查询账户信息

-- 查询数据量

/*{"xdb_comment":"1","table":"mb_tran_hist","pk_value":"0"}*/

select base_acct_no,count(1) num from mb_tran_hist groupby base_acct_no ORDERBY num desc;

/*{"xdb_comment":"1","table":"mb_tran_hist","pk_value":"1"}*/

select base_acct_no,count(1) num from mb_tran_hist groupby base_acct_no ORDERBY num desc;

/*{"xdb_comment":"1","table":"mb_tran_hist","pk_value":"2"}*/

select base_acct_no,count(1) num from mb_tran_hist groupby base_acct_no ORDERBY num desc;

/*{"xdb_comment":"1","table":"mb_tran_hist","pk_value":"3"}*/

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

 

常用核心数据库查询sql

以上是 常用核心数据库查询sql [数据库教程] 的全部内容, 来源链接: utcz.com/z/534755.html

回到顶部