Discussion Forum
Que. | Database table by name Loan_Records is given below. Borrower Bank_Manager Loan_Amount Ramesh Sunderajan 10000.00 Suresh Ramgopal 5000.00 Mahesh Sunderajan 7000.00 What is the output of the following SQL query? SELECT Count(*) FROM ( (SELECT Borrower, Bank_Manager FROM Loan_Records) AS S NATURAL JOIN (SELECT Bank_Manager, Loan_Amount FROM Loan_Records) AS T ); |
a. | 3 |
b. | 9 |
c. | 5 |
d. | 6 |
Answer:5 |
Dharani Allamsetty :(September 05, 2020)
Cannot understand
|
Total number of persons 5. |
Click Here to Reply |