The SQL expression

Select distinct T. branchname from branch T, branch S where T. assets > S. assets and S. branchcity = "XYZ"

Finds the names of

1
All branches that have greater assets than some branch located in XYZ
2
All branches that have greater assets than all branches located in XYZ
3
The branch that has the greatest asset in XYZ
4
Any branch that has greater asset than any branch located in XYZ
5
Question Not Attempted

Sponsored

hivanix.in

Visit

This quiz is brought to you by hivanix.in

🌐 Web App Development

Quick Navigation