A database contains three tables - saving_accnt(cid, accnt_no, owner, balance), current_accnt(cid, accnt_no, owner, balance) and customer(cid, accnt_no). "a" is the alias for the saving_accnt table and b is the alias for the current_accnt table. Which queries should be used to show the details of a customer who holds a savings account as well as a current account?

Answers 2

Explanation:

we jave to join the tables and write a query by thay where the customer have both savings and current account

Answer:

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

If you know the answer add it here!

Can't find the answer?

Log in with Google

or

Forgot your password?

I don't have an account, and I want to Register

Choose a language and a region
How much to ban the user?
1 hour 1 day 100 years