Advertisements
Advertisements
प्रश्न
Consider the following tables – Bank_Account and Branch:
Table: Bank_Account
| ACode | Name | Type |
| A01 | Amrita | Savings |
| A02 | Parthodas | Current |
| A03 | Miraben | Current |
Table: Branch
| ACode | City |
| A01 | Delhi |
| A02 | Mumbai |
| A01 | Nagpur |
What will be the output of the following statement?
SELECT * FROM Bank_Account NATURAL JOIN Branch;
टीपा लिहा
Advertisements
उत्तर
| ACode | Name | Type | City |
| A01 | Amrita | Savings | Delhi |
| A01 | Amrita | Savings | Nagpur |
| A02 | Parthodas | Current | Mumbai |
shaalaa.com
SQL for Data Query
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
