User Tools

Site Tools


oracle:sql:select:select_count

Oracle - SQL - Select - Select Count

SELECT COUNT(*) FROM 
(
SELECT a.*, b.CMPY_N, b.CUST_ACNT_N FROM [BeaconPhase2_DEV].[BCN].[AGENTS_LOG_MSG] a LEFT JOIN 
[BeaconPhase2_DEV].[BCN].[CUST_STATIC] b ON a.CUST_K = b.CUST_K
) AS subquery;  
oracle/sql/select/select_count.txt · Last modified: 2021/08/11 12:33 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki