The SQL expression Select distinct T, branch_name from branch T, branch S…
PYQ UGC NET 2013
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
- A.
All branches that have greater assets than some branch located in Mumbai.
- B.
All branches that have greater assets than all branches in Mumbai.
- C.
The branch that has greatest asset in Mumbai.
- D.
Any branch that has greater assets than any branch in Mumbai.
Attempted by 176 students.
Sign up free to check your answer
Sign up freeLoading lesson…

