i need write 1 statement gets sum of total number of customers , sum of accounts. able each individually can not them 1 statement. error message mean, should from go?
this statement loan total
sql> select sum(amount) "total" loan, borrower borrower.loan_number = loan.loan_number; this statement number of customers
sql> select count(*) customer; i have combined them error message can see.
> sql> select 2 (select count(*) "total customers" customer) 3 (select sum(amount) "total loan values" 4 borrower, loan 5 borrower.loan_number = loan.number); (select sum(amount) "total loan values" * error @ line 3: ora-00923: keyword not found expected
since query customer returns single line, cross join other question:
select sum(amount) total, cnt loan join borrower on borrower.loan_number = loan.loan_number; cross join (select count(*) cnt customer)
Comments
Post a Comment