查询sql： select loan_id,count(1) count from loan_application_v7 group by loan_id having count > 1; 结果：+-------------+-------+ | loan_id | count | +-------------+-------+ | 9992910006 | 2 | | 6219310002 | 2 | | 9988650003 | 2 | | 11507850002 | 2 | | 6214400003 | 2 | | 11509960008 | 2 | | 11520870001 | 2 | | 9988140009 | 2 | | 9988160010 | 2 | | 9990600007 | 2 | | 6213530003 | 2 | | 6221520003 | 2 | | 9989650002 | 2 | | 6216700006 | 2 | | 11515600008 | 2 | | 11516580007 | 2 | | 6213200006 | 2 | | 11514860009 | 2 | +-------------+-------+
select count(1) from loan_application_v7 where loan_id = 9992910006; +----------+ | count(1) | +----------+ | 1 | +----------+ [ Full content available at: https://github.com/apache/incubator-doris/issues/238 ] This message was relayed via gitbox.apache.org for [email protected]
