Subject:
CBSE BOARD XIIAuthor:
karlieCreated:
1 year agoExplanation:
we jave to join the tables and write a query by thay where the customer have both savings and current account
Author:
janellecnm9
Rate an answer:
2Answer:
The correct answer is using the method of SQL.
Explanation:
Saving account (cid, account_no, owner, balance)
Current_account (cid, account_no, owner, balance)
Customer (cid, account_no).
BY applying the above, we get a value,
select
BANK_BRANCH.R
BANK_BRANCH.RSDAM
count(1) as TOTAL_ACCOUNT
from BANK_BRANCH
left join ACCOUNT
on BANK_BRANCH.RSDAM = ACCOUNT.R
group by
BANK_BRANCH.R
BANK_BRANCH.RSDAM
From, the above queries entered it consists of three tables and by entering these details we can conclude that the details of a customer who holds a savings account as well as a current account.
#SPJ3
Author:
orestespadilla
Rate an answer:
2