The SQL expression

Select distinct T.branch_name from branch T, branch S

where T.assets>S.assets and

S.branch_city="Mumbai" finds the names of

1
All branches that have greater assets than some branch located in Mumbai.
2
All branches that have greater assets than all branches in Mumbai.
3
The branch that has greatest asset in Mumbai.
4
Any branch that has greater assets than any branch in Mumbai.
5
None of above

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation