Database table by name Loan_Records is given below. Borrower Bank_Manager…
GATE · 2011 · CS · Computer Science & IT
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
Attempted by 242 students.
Sign up free to check your answer
Sign up freeLoading lesson…