How do I? (1 Viewer)

icedearth

Registered User.
Local time
Today, 12:41
Joined
Oct 10, 2008
Messages
24
Hi!

I want to count loan_num nad how many accounts by branch something like the picture of excel. if i need something else tell me.

thanks appreciated
 

Attachments

  • New query.JPG
    New query.JPG
    67.5 KB · Views: 88
  • New Query Result.JPG
    New Query Result.JPG
    94.9 KB · Views: 99
  • Excel Result.jpg
    Excel Result.jpg
    89.8 KB · Views: 89

Brianwarnock

Retired
Local time
Today, 15:41
Joined
Jun 2, 2003
Messages
12,701
If all that you want is the count of Loan number per Sercusal per Region then they are the only fields to select counting the first and group by the last 2.

I posted the above on your previous thread, did it not point you in the direction to go?

Brian
 

icedearth

Registered User.
Local time
Today, 12:41
Joined
Oct 10, 2008
Messages
24
i think i put it the wrong way and gave me various errors. and i want to export this to excel if this is possibble.
 

jal

Registered User.
Local time
Today, 08:41
Joined
Mar 30, 2007
Messages
1,709
I am not sure how to get all those figures. Maybe someone else can help - but I think a starting point would be some kind of a GROUP BY clause, something like this:

SELECT Branch_Number, Count(Loan_Num) as LoanCount
FROM DBA_INC_LOAN_Bank
GROUP BY Branch_Number
 
Last edited:

Users who are viewing this thread

Top Bottom